Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

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

To create a cursor using an ODBC connection, you can use the native ODBC interface. For details, see database.

Related Examples

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

|

Introduced before R2006a

Was this topic helpful?