querytimeout

(Not recommended) Get time specified for SQL queries to succeed

The querytimeout function is not recommended. There is no replacement for this functionality. To import data, use the fetch function. For details, see Compatibility Considerations.

Syntax

timeout = querytimeout(curs)

Description

timeout = querytimeout(curs) returns the amount of time, in seconds, allowed for SQL queries of the open cursor object 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 object using an ODBC connection, you can use the native ODBC interface. For details, see database.

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.

Compatibility Considerations

expand all

`querytimeout` function is not recommended

Not recommended starting in R2018b

The querytimeout function is not recommended. Use the fetch function to import data. Some differences between the workflows might require updates to your code.

There are no plans to remove the querytimeout function at this time.

Update Code

Use the fetch function with the connection object to import data from a database in one step.

In prior releases, you wrote multiple lines of code to create the cursor object, import data, and determine the current database timeout value. For example:

curs = exec(conn,sqlquery);
curs = fetch(curs);
results = curs.Data;
timeout = querytimeout(curs);
close(curs)

Now you can import data in one step using the fetch function.

results = fetch(conn,sqlquery);

There is no replacement functionality for the querytimeout function.

Documentation

querytimeout

Syntax

Description

Examples

Limitations

Compatibility Considerations

`querytimeout` function is not recommended

See Also

Database Toolbox Documentation

Support

Documentation

querytimeout

Syntax

Description

Examples

Limitations

Compatibility Considerations

querytimeout function is not recommended

See Also

Database Toolbox Documentation

Support

`querytimeout` function is not recommended