Data Set Options for DB2 under UNIX and PC Hosts

All SAS/ACCESS data set options in this table are supported for DB2 under UNIX and PC Hosts. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for DB2 under UNIX and PC Hosts
Option	Default Value
BL_ALLOW_READ_ACCESS=	NO
BL_ALLOW_WRITE_ACCESS=	NO
BL_CODEPAGE=	the code page ID for the window
BL_COPY_LOCATION=	none
BL_CPU_PARALLELISM=	none
BL_DATA_BUFFER_SIZE=	none
BL_DATAFILE=	the temporary directory that is specified by the UTILLOC= system option
BL_DELETE_DATAFILE=	YES
BL_DISK_PARALLELISM=	none
BL_EXCEPTION=	none
BL_INDEXING_MODE=	AUTOSELECT
BL_LOAD_REPLACE=	NO
BL_LOG=	the temporary directory that is specified by the UTILLOC= system option
BL_METHOD=	CLILOAD
BL_OPTIONS=	none
BL_PORT_MAX=	none
BL_PORT_MIN=	none
BL_RECOVERABLE=	NO
BL_REMOTE_FILE=	none
BL_SERVER_DATAFILE=	the temporary directory that is specified by the UTILLOC= system option
BL_WARNING_COUNT=	2147483646
BULKLOAD=	NO
CHAR_AS_BINARY=	NO
CURSORTYPE=	LIBNAME option value
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	LIBNAME option value
DBKEY=	none
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	_ALL_=YES
DBNULLKEYS=	LIBNAME option value
DBNULLWHERE=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for DB2 under UNIX and PC Hosts
DBSLICE=	none
DBSLICEPARM=	NONE
DBTYPE=	see Data Types for DB2 under UNIX and PC Hosts
ERRLIMIT=	1
FETCH_IDENTITY=	NO
IGNORE_READ_ONLY_COLUMNS=	NO
IN=	LIBNAME option value
INSERTBUFF=	LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
PRESERVE_COL_NAMES=	LIBNAME option value
QUERY_TIMEOUT=	LIBNAME option value
READ_ISOLATION_LEVEL=	LIBNAME option value
READ_LOCK_TYPE=	LIBNAME option value
READBUFF=	LIBNAME option value
SASDATEFMT=	none
SCHEMA=	LIBNAME option value
UPDATE_ISOLATION_LEVEL=	LIBNAME option value
UPDATE_LOCK_TYPE=	LIBNAME option value
UPDATE_SQL=	LIBNAME option value

Last updated: February 3, 2026