CODEWITHSUNDEEP
sqllockinginformix
sana
sana

Reputation: 251

How to set row level lock in Informix?

How to set row level lock in Informix?

Upvotes: 1

Views: 3752

Answers (3)

Zanon
Zanon

Reputation: 30710

You can use:

ALTER TABLE customer LOCK MODE(ROW);

(PAGE is the default)

More here.

If you want to find the current lock mode of a table:

SELECT tablename, lockmode FROM systables

Upvotes: 1

Rameez
Rameez

Reputation: 1712

CREATE TABLE customer(customer_num serial, lname char(20)...)
   LOCK MODE ROW;

Read more here: Row and Key Locks

Upvotes: 1

David
David

Reputation: 1

Onstat with a hyphen argument

onstat -

Onstat Documentation

Upvotes: 0

Related Questions