Re: dbaccess buffer
If your database is not ANSI then you'll have to explicitly start the
transaction by typing "begin work" and completing it with "commit work" if
you want to club all the three statements in one transaction. Otherwise,
each statement will be running in its own transaction ... u can check that
in the logs using the onlog command.
HTH
Thanx much,
Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
xwaxman@earthlink
.net (Xeth To: informix-list@iiug.org
Waxman) cc:
Sent by: Subject: dbaccess buffer
owner-informix-li
st@iiug.org
09/09/2003 02:58
PM
Please respond to
xwaxman
In dbaccess (for me, Informix 7.31), if I have the following
statements:
set lock mode to wait;
update table set column = 'X' where columnPK = 1;
update table set column = 'X' where columnPK = 2;
update table set column = 'X' where columnPK = 3;
I am under the assumption that each trasnaction is committed after the
semicolon - so in effect, I am making three distinct trasnactions to
the log (and the buffer). However, my colleague believes this would
be one transaction - so if the above statement repeated up to 15,000,
I would be locking out 15k rows. Is he correct?
sending to informix-list