QUERY_TIMEOUT= LIBNAME Option

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

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.