Database Toolbox™

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

• If a given database does not have a database timeout feature, it returns the following:

  [Driver]Driver not capable
  

• ODBC drivers for Microsoft^® Access™ and Oracle^® do not support querytimeout.

See Also

exec

querybuilder

register