Previous Page | Next Page

The LIBNAME Statement for Relational Databases

QUERY_TIMEOUT= LIBNAME Option



Specifies the number of seconds of inactivity to wait before canceling a query.
Default value: 0
Valid in: SAS/ACCESS LIBNAME statement and some DBMS-specific connection options. Please see your DBMS for details.
DBMS support: Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, Sybase IQ

Syntax
Details
See Also

Syntax

QUERY_TIMEOUT=number-of-seconds


Details

The default value of 0 indicates that there is no time limit for a query. This option is useful when you are testing a query or if you suspect that a query might contain an endless loop.


See Also

To apply this option to an individual data set, see the QUERY_TIMEOUT= Data Set Option.

Previous Page | Next Page | Top of Page