Data Set Options for Relational Databases DBCONDITION= Data Set Option 171
DB2 UNIX/PC Details: When BULKLOAD=YES, the default is 10000.
Teradata Details: The Teradata interface alias for this option is CHECKPOINT. See
the Fastload capability description in the SAS/ACCESS documentation for Teradata for
the default behavior of this option.
Example
In the following example, a commit is issued after every 10 rows are inserted:
data oracle.dept(dbcommit=10);
set myoralib.staff;
run;
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “DBCOMMIT= LIBNAME Option” on page 84.
DBCONDITION= Data Set Option
Specifies criteria for subsetting and ordering DBMS data
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value: none
Syntax
DBCONDITION="DBMS-SQL-query-clause"
Syntax Description
DBMS-SQL-query-clause
is a DBMS-specific SQL query clause, such as WHERE, GROUP BY, HAVING, or
ORDER BY.
Details
This option enables you to specify selection criteria in the form of DBMS-specific SQL
query clauses, which the SAS/ACCESS engine passes directly to the DBMS for
processing. When selection criteria are passed directly to the DBMS for processing,
performance is often enhanced. The DBMS checks the criteria for syntax errors when it
receives the SQL query.
The DBKEY= and DBINDEX= options are ignored when you use DBCONDITION=.
