RE: Row level locking
Posted in 1999
Murray Wood — — source: Informix-list mailing list archive (1991-1998)
You can (should) do it when creating the table (see sql create table).
If you want to change a current table ..
alter table my_table lock mode (row);
HTH
Murray Wood
-----Original Message-----
From: Alex [SMTP:lexheidi@zeelandnet.nl]
Sent: Friday, November 05, 1999 11:56 AM
To: informix-list@iiug.org
Subject: Row level locking
Hi,
Our application wants to use row level locking on his tables.
Do I have to set the system catalog tables also at row level locking our
leave them on page level?
Working with 7.13 and in a couple of weeks on 7.24.
Thanks,
Alex