how can I lock with ODBC ?

Posted in 1997

Topics: SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL

Marcus Kallabis — Mon, 06 Oct 1997 15:14:54 +0200 — source: Informix-list mailing list archive (1991-1998)

Hello, I try to lock rows in a table using a "select for update" statement. When I execute the select statement and the update statement and start parallel a second process doing the same I get no error message. If I execute the select for update within a ESQL/C programm and start a second process I get a message that the row is locked. I'm using Informix CLI 2.5 (from the Online Workstation 7.20 for Windows NT) under Windows NT 4.0. The server is an Informix OnLine 7.10 on a SCO Unix machine. I use the connect option SQL_ODBC_CURSOR = SQL_CUR_USE_DRIVER and the statement options SQL_CONCURRENCY = SQL_CONCUR_LOCK and SQL_CURSOR_TYPE = SQL_CURSOR_KEYSET_DRIVEN. Thanks for any idea to solve this problem or clearing up my misunderstanding of locking with ODBC. Marcus Kallabis mailto:marcus@halstenbach.de Halstenbach ACT GMBH http://www.halstenbach.de Breidenbrucher Strasse 2 phone: +49 2261 9902 0 51674 Wiehl-Bomig fax: +49 2261 9902 99

Glossary

ESQL/C