Re: LOCKING TABLES w/ TRANSACTIONS

Posted in 1992

Dave Snyder — Mon, 13 Jul 92 12:41:47 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting robert.a.balko... > Does this look right to you?? > BEGIN WORK > > LOCK TABLE BILLS > LOCK TABLE ORDERS > > DO UPDATES > > UNLOCK TABLE ORDERS > UNLOCK TABLE BILLS > > COMMIT WORK No, here is the syntax for LOCK TABLE: LOCK TABLE tabname IN {SHARE|EXCLUSIVE} MODE Also, if the database has transactions, the UNLOCK TABLE statement can not be used and generates an error. All locks on the table are released when the COMMIT WORK or ROLLBACK WORK statement is executed. Jeese... I don't usually say this, but this was definately a RTFM question. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.7 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com