Problem:

Is there a way to set the SQL ODBC Query Timeout using OpenESQL ?

Resolution:

Yes, You can use the SET OPTION statement.

EXEC SQL SET OPTION QUERYTIME value END-EXEC

Where value is the number of seconds the program will wait for a response, the default is 0 which means it will wait forever.

NOTE: This option may not be supported by all ODBC drivers.

In addition, you can use a signed comp-5 host variable for the numeric value.