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 details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for DB2 under z/OS
Option	Default Value
AUTHID=	current LIBNAME option value
BL_DBCURSOR=	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_DB2STRT=	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
BUSINESS_DATATYPE=	TIMESTAMP(6)
BUSINESS_TIMEFRAME=	none
DBCOMMIT=	current LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	current LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBKEY=	none
DBLABEL=	NO
DBLARGETABLE=	none
DBNULL=	YES
DBNULLKEYS=	current LIBNAME option value
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 value
LOCATION=	current LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
OVERLAPS=	column names separated by commas
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
PRESERVE_COL_NAMES=	current LIBNAME option value
READBUFF=	current LIBNAME option value
READ_ISOLATION_LEVEL=	current LIBNAME option value
READ_LOCK_TYPE=	current LIBNAME option value
SCHEMA=	current LIBNAME option value
SYSTEM_TIMEFRAME=	none
TEMPORAL=	none
TRAP_151=	NO
UPDATE_ISOLATION_LEVEL=	current LIBNAME option value
UPDATE_LOCK_TYPE=	current LIBNAME option value

Last updated: February 3, 2026