ESQL/C & "SET LOCK MODE TO WAIT"

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Francois Baligant — Tue, 28 Sep 1999 08:40:09 +0200 — source: Informix-list mailing list archive (1991-1998)

The subject pretty says it all. Should I send an SQL query with this directive or is there a function for that in the ESQL/C library (I have search for it but didn't find it) Regards, Francois

↪ replying to Francois Baligant

Andy Lennard — Tue, 28 Sep 1999 09:52:18 +0100 — source: Informix-list mailing list archive (1991-1998)

In your .ec file, include... $ set lock mode to wait; In article <37F062C9.3441535@be.euro.net>, Francois Baligant <francois@be.euro.net> writes > > The subject pretty says it all. Should I send an SQL > query with this directive or is there a function for > that in the ESQL/C library (I have search for it but > didn't find it) > > Regards, > Francois Andrew Lennard andy@kontron.demon.co.uk

↪ replying to Francois Baligant

Art S. Kagel — Tue, 28 Sep 1999 11:28:02 -0400 — source: Informix-list mailing list archive (1991-1998)

Just issue the SQL directive as: EXEC SQL SET LOCK MODE TO WAIT; or EXEC SQL SET LOCK MODE TO WAIT :nsecs; where nsecs is an integer host variable set to the number of seconds to wait. Art S. Kagel Francois Baligant wrote: > > The subject pretty says it all. Should I send an SQL > query with this directive or is there a function for > that in the ESQL/C library (I have search for it but > didn't find it) > > Regards, > Francois

Glossary

ESQL/C