Specifies the number of seconds of inactivity to wait before canceling a query.
| Valid in: | SAS/ACCESS LIBNAME, CONNECT statement |
|---|---|
| Category: | Data Set Control |
| Alias: | TIMEOUT= [Greenplum, HAWQ, Microsoft SQL Server, SAP IQ] |
| Default: | 0 |
| Interaction: | Set the SAS SQLIPONEATTEMPT system option to disable PROC SQL from trying the query again after the first query times out. |
| Data source: | Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, Greenplum, Hadoop, HAWQ, Impala, JDBC, Microsoft SQL Server, Netezza, ODBC, PostgreSQL, SAP IQ, Snowflake, Vertica, Yellowbrick |
| Note: | Support for Yellowbrick was added in SAS 9.4M7. |
| See: | QUERY_TIMEOUT= data set option, SQLIPONEATTEMPT system option |
Table of Contents
specifies a positive integer for the number of seconds to wait before canceling the query. 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.