Lock Table and auto commit

#1 November 17th, 2008, 05:05 AM

When I use LOCK TABLE ... COMMIT, must I also use
odbc_autocommit(dbConn, FALSE)? In other words will auto commit
prematurely defeat the LOCK TABLE?

#2 November 17th, 2008, 08:15 AM

On Nov 17, 10:04*am, robert stearns <rstearns1...@charter.netwrote:

Quote:

When I use LOCK TABLE ... COMMIT, must I also use
odbc_autocommit(dbConn, FALSE)? In other words will auto commit
prematurely defeat the LOCK TABLE?

Yes, a COMMIT will release all locks.

Best regards,
ram

#3 November 17th, 2008, 11:55 AM

robert stearns wrote:

Quote:

When I use LOCK TABLE ... COMMIT, must I also use
odbc_autocommit(dbConn, FALSE)? In other words will auto commit
prematurely defeat the LOCK TABLE?

Yes, if the client drives a commit implicitly you're going nowhere :-)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

re: Lock Table and auto commit