Re: Informix SE and ODBC Locking

Norm Almond wrote: > I'm I correcting saying you can't lock a record (after a read/select) using > the Informix Client SDK ODBC driver 3.81TC2 with Informix SE as the > database? It depends on whether you put a FOR UPDATE clause at the end of the SELECT statement. If you do, the row will be locked as you read it. If you don't, it won't. If you really want to lock after reading, you'd have to re-read using a statement with the FOR UPDATE clause (and, presumably, using the primary key to identify the exact row). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/