User`s guide

querytimeout
7-193
querytimeout
Get time specified for SQL queries to succeed
Syntax
timeout = querytimeout(curs)
Description
timeout = querytimeout(curs) returns the amount of time, in seconds, allowed for
SQL queries of the open cursor curs to succeed. If a given query cannot complete in the
specified time, the toolbox stops trying to perform the query.
The database administrator defines timeout values. If the timeout value is zero, queries
must complete immediately.
Examples
Get the current database timeout setting for curs.
querytimeout(curs)
ans =
10
Limitations
• This error message displays if a given database does not have a database timeout
feature:
[Driver]Optional feature not implemented
• ODBC drivers for Microsoft Access and Oracle do not support querytimeout.
See Also
exec