| Data Set Options for Relational Databases |
Specifies
the number of seconds of inactivity to wait before canceling
a query.
| Default value: |
LIBNAME setting
|
| Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
| 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
|
QUERY_TIMEOUT= 0 indicates that there
is no time limit for a query. This option is useful when you are testing
a query, you suspect that a query might contain an endless loop, or the data
is locked by another user.
To assign this option to a group of relational
DBMS tables or views, see the QUERY_TIMEOUT= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
