Hi,

With DB2 SDK 8.2.1, if I try to do a "SET LOCK MODE TO [NOT WAIT|WAIT x|TIMEOUT] I get an error :

"DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "LOCK" was found following "SET CURRENT ".
Expected tokens may include: "DEGREE". SQLSTATE=42601"

Has the database to be configured to support SET LOCK MODE statement ?

Geoffrey

I'd try reading the SQL reference if I were you

I've find the following in the DB2 V8 documentation : here

set lock timeout not wait

This doesn't look like DB2 documentation to me - it says "Informix" right at the top...

Oops, i was redirect there FROM db2 documentation center !!

OK, i'll look further


Edit :

I've to use SET CURRENT LOCK TIMEOUT" statement. But this one still gives me an error (i've try the exemple from here)

db2 => SET CURRENT LOCK TIMEOUT 30
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "LOCK TIMEOUT 30" was found following "SET
CURRENT ". Expected tokens may include: "<space>". SQLSTATE=42601