Re: Row level lock [1899]

Posted in 2003

Mark Denham — Thu, 18 Sep 2003 09:02:24 -0400 — source: Usenet: comp.databases.informix

Don't go updating systables. This is not the correct approach. Alter table <tabname> lock mode row; Mark ----- Original Message ----- From: "MARCELO MUSRI" <marmus@inv.gov.ar> To: <ids@iiug.org> Sent: Thursday, September 18, 2003 06:38 Subject: Row level lock [1899] > Hi, my name is Marcelo, we are running IDS 7.3 over SCO OpenServer 5.0.5. > > We need in one of our applications to lock a table at row level, but by default is set in page mode. > > The question is: > > - The DBA can update the systable for that table in column locklevel setting it with value "R". If it is like this, what else do I have to do to take effect this change in the table ? > > - The programmers must do anything in the 4gl source file ? > > Thank you for your response. > sending to informix-list