Data Set Options for Relational Databases RDBCONST= Data Set Option 203
QUERY_TIMEOUT= Data Set Option
Specifies the number of seconds of inactivity to wait before canceling a query
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 UNIX/PC, ODBC, Microsoft SQL Server
Default value:
LIBNAME setting
Syntax
QUERY_TIMEOUT=number-of-seconds
Details
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.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “QUERY_TIMEOUT= LIBNAME Option” on page 116.
RDBCONST= Data Set Option
Enables you to override the Oracle Rdb default action of evaluating constraints at commit time
(this option has no effect on constraints that must be evaluated at commit time)
Valid in: DATA and PROC steps (when accessing DBMS data using PROC ACCESS,
PROC DBLOAD, or the Pass-Through Facility)
DBMS support:
Oracle Rdb
Default value:
OFF
Syntax
RDBCONST= OFF | ON
Syntax Description
OFF
means that a commit might not occur until several rows of data have been entered.
Be aware that if RDBCONST=OFF and you enter a NULL value for a column that
has been defined as NOT NULL, you are not notified of the error until commit time.
