SAS/ACCESS Interface to DB2 Under UNIX and PC Hosts

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 general information about this feature, see About the 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 window's codepage ID
BL_COPY_LOCATION=	none
BL_CPU_PARALLELISM	none
BL_DATA_BUFFER_SIZE	none
BL_DATAFILE=	the current directory
BL_DELETE_DATAFILE=	YES
BL_DISK_PARALLELISM	none
BL_EXCEPTION	none
BL_INDEXING_MODE=	AUTOSELECT
BL_LOAD_REPLACE=	NO
BL_LOG=	the current directory
BL_METHOD=	none
BL_OPTIONS=	none
BL_PORT_MAX=	none
BL_PORT_MIN=	none
BL_RECOVERABLE=	NO
BL_REMOTE_FILE=	none
BL_SERVER_DATAFILE=	creates a data file in the current directory or with the default file specifications (same as for BL_DATAFILE=)
BL_WARNING_COUNT=	2147483646
BULKLOAD=	NO
CURSOR TYPE=	LIBNAME option setting
DBCOMMIT=	LIBNAME option setting
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option setting
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	LIBNAME option setting
DBKEY=	none
DBLABEL=	NO
DBMASTER=	none
DBMAX_TEXT=	1024
DBNULL=	_ALL_=YES
DBNULLKEYS=	LIBNAME option setting
DBPROMPT=	LIBNAME option setting
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for DB2 Under UNIX and PC Hosts
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,3
DBTYPE=	see Data Types for DB2 Under UNIX and PC Hosts
ERRLIMIT=	NO
FETCH_IDENTITY=	1
IGNORE_ READ_ONLY_COLUMNS=	NO
IN=	LIBNAME option setting
INSERTBUFF=	LIBNAME option setting
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
PRESERVE_COL_NAMES=	LIBNAME option setting
QUERY_TIMEOUT=	LIBNAME option setting
READ_ISOLATION_LEVEL=	LIBNAME option setting
READ_LOCK_TYPE=	LIBNAME option setting
READBUFF=	LIBNAME option setting
SASDATEFMT=	none
SCHEMA=	LIBNAME option setting
UPDATE_ISOLATION_LEVEL=	LIBNAME option setting
UPDATE_LOCK_TYPE=	LIBNAME option setting

Top of Page