The LIBNAME Statement for Relational Databases |
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
|
QUERY_TIMEOUT=number-of-seconds
|
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.
To apply this option to an individual data set,
see
the QUERY_TIMEOUT= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.