Re: Row level lock [1899]

#1

Don't go updating systables. This is not the correct approach.

Alter table <tabname> lock mode row;

Mark

----- Original Message -----
From: "MARCELO MUSRI" <marmus (AT) inv (DOT) gov.ar>
To: <ids (AT) iiug (DOT) org>
Sent: Thursday, September 18, 2003 06:38
Subject: Row level lock [1899]

Quote:

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 ?

Quote:

- The programmers must do anything in the 4gl source file ?

Thank you for your response.

sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Row level lock [1899]

comp.databases.informix comp.databases.informix

Re: Row level lock [1899] - 09-18-2003 , 08:02 AM