Lock Table and auto commit

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?

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

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