Data Set Options for SAP ASE

All SAS/ACCESS data set options in this table are supported for SAP ASE. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for SAP ASE
Option	Default Value
AUTOCOMMIT=	LIBNAME option value
BULK_BUFFER=	100
BULKLOAD=	NO
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	LIBNAME option value
DBINDEX=	LIBNAME option value
DBKEY=	none
DBLABEL=	NO
DBLINK=	LIBNAME option value
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	_ALL_=YES
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,2 or THREADED_APPS,3
DBTYPE=	see Data Types for SAP ASE
ERRLIMIT=	1
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
READBUFF=	LIBNAME option value
READ_ISOLATION_LEVEL=	LIBNAME option value
READ_LOCK_TYPE=	LIBNAME option value
SASDATEFMT=	DATETIME22.3
SCHEMA=	LIBNAME option value
SEGMENT_NAME=	none
UPDATE_ISOLATION_LEVEL=	LIBNAME option value
UPDATE_LOCK_TYPE=	LIBNAME option value

Last updated: February 3, 2026