Chapter Contents
Previous
Next
|
Chapter Contents |
Previous |
Next |
| SAS/ACCESS Software for Relational Databases: Reference |
This section describes options that can be applied to SAS data sets that access data in DB2 tables and views. In some cases, the option is fully described in SAS/ACCESS Data Set Options , except for some detail that is specific to DB2, such as a default value. In other cases, the entire option is specific to DB2, so it is fully described in this chapter.
When specified in a DATA step or SAS procedure, the following data set options can be used on a SAS data set that accesses data in a DBMS object, such as a table or view. A data set option applies only to the SAS data set on which it is specified.
The SAS/ACCESS interface to DB2 supports all of the SAS/ACCESS data set options listed in SAS/ACCESS Data Set Options. In addition to the supported options, the following data set options are used only in the interface to DB2 or have DB2-specific aspects to them:
| CURSOR_TYPE= | |
| DBINDEX= | |
| DBNULL= | |
| DBSASTYPE= | |
| DBTYPE= | |
| QUERY_TIMEOUT= | |
| READ_ISOLATION_LEVEL= | |
| READ_LOCK_TYPE= | |
| ROWSET_SIZE= | |
| SASDATEFMT= | |
| SCHEMA= | |
| UPDATE_ISOLATION_LEVEL= | |
| UPDATE_LOCK_TYPE= |
|
Chapter Contents |
Previous |
Next |
 Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.