 |
|
| SAS/ACCESS Interface to DB2 Under z/OS |
Data Set Options for DB2 Under z/OS
All SAS/ACCESS data set options in this table are supported for SAS/ACCESS Interface to DB2 under z/OS. Default values are provided where applicable. For general information about this feature, see About the Data Set Options for Relational Databases.
| Option | Default Value |
|---|---|
|
AUTHID= |
current LIBNAME option setting |
|
BL_DB2CURSOR= |
none |
|
BL_DB2DATACLAS= |
none |
|
BL_DB2DEVT_PERM= |
SYSDA |
|
BL_DB2DEVT_TEMP= |
SYSDA |
|
BL_DB2DISC= |
a generated data set name |
|
BL_DB2ERR= |
a generated data set name |
|
BL_DB2IN= |
a generated data set name |
|
BL_DB2LDCT1= |
none |
|
BL_DB2LDCT2= |
none |
|
BL_DB2LDCT3= |
none |
|
BL_DB2LDEXT= |
GENRUN |
|
BL_DB2MAP= |
a generated data set name |
|
BL_DB2MGMTCLAS= |
none |
|
BL_DB2PRINT= |
a generated data set name |
|
BL_DB2PRNLOG= |
YES |
|
BL_DB2REC= |
a generated data set name |
|
BL_DB2RECSP= |
10 |
|
BL_DB2RSTRT= |
NO |
|
BL_DB2SPC_PERM= |
10 |
|
BL_DB2SPC_TEMP= |
10 |
|
BL_DB2STORCLAS= |
none |
|
BL_DB2TBLXST= |
NO |
|
BL_DB2UNITCOUNT= |
none |
|
BL_DB2UTID= |
user ID and second level DSN qualifier |
|
BULKLOAD= |
NO |
|
DBCOMMIT= |
current LIBNAME option setting |
|
DBCONDITION= |
none |
|
DBCREATE_TABLE_OPTS= |
current LIBNAME option setting |
|
DBFORCE= |
NO |
|
DBGEN_NAME= |
DBMS |
|
DBKEY= |
none |
|
DBLABEL= |
NO |
|
DBMASTER= |
none |
|
DBNULL= |
YES |
|
DBNULLKEYS= |
current LIBNAME option setting |
|
DBSASLABEL= |
COMPAT |
|
DBSASTYPE= |
see Data Types for DB2 Under z/OS |
|
DBSLICE= |
none |
|
DBSLICEPARM= |
THREADED_APPS,2 |
|
DBTYPE= |
none |
|
DEGREE= |
ANY |
|
ERRLIMIT= |
1 |
|
IN= |
current LIBNAME option setting |
|
LOCATION= |
current LIBNAME option setting |
|
NULLCHAR= |
SAS |
|
NULLCHARVAL= |
a blank character |
|
PRESERVE_COL_NAMES= |
current LIBNAME option setting |
|
READBUFF= |
LIBNAME setting |
|
READ_ISOLATION_LEVEL= |
current LIBNAME option setting |
|
READ_LOCK_TYPE= |
current LIBNAME option setting |
|
TRAP_151= |
NO |
|
UPDATE_ISOLATION_LEVEL= |
current LIBNAME option setting |
|
UPDATE_LOCK_TYPE= |
current LIBNAME option setting |
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.