Data Set Options for SAP HANA

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

Option	Default Value
BL_CONTROL_FIELD_DELIMITER=	, (comma)
BL_CONTROL_RECORD_DELIMITER=	'\n' (newline)
BL_CONTROL_QUOTATION_MARK=	' (single quotation mark)
BL_FILE_BADFILE=	creates a file in the current directory or with the default file specifications
BL_FILE_CONTROLFILE=	creates a file in the current directory or with the default file specifications
BL_FILE_DATAFILE=	creates a file in the current directory or with the default file specifications
BL_FILE_DEFAULT_DIR=	NO
BL_FILE_DELETE_DATAFILE=	'/tmp/'
BL_IMPORT_BATCH_SIZE=	none
BL_IMPORT_OPTIONS=	none
BL_IMPORT_TABLE_LOCK=	NO
BL_IMPORT_TYPE_CHECK=	NO
BL_SFTP_HOST=	none
BL_SFTP_OPTIONS=	none
BL_SFTP_USER=	none
BL_SFTP_WAIT_MILLISECONDS=	none
BULKLOAD=	NO
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	NO
DBKEY=	none
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	LIBNAME option value
DBNULLWHERE=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASLABEL=	LIBNAME option value
DBSASTYPE=	see Data Types for SAP HANA
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,2 or THREADED_APPS,3
DBTYPE=	see Data Types for SAP HANA
ERRLIMIT=	1
IGNORE_READ_ONLY_COLUMNS=	NO
INSERTBUFF=	LIBNAME option value
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
PARMDEFAULT=	none
PARMSTRING=	none
PRESERVE_COL_NAMES=	LIBNAME option value
QUERY_TIMEOUT=	LIBNAME option value
READ_LOCK_TYPE=	LIBNAME option value
READBUFF=	LIBNAME option value
SASDATEFMT=	none
SCHEMA=	LIBNAME option value
SUB_CHAR=	none
TABLE_TYPE=	none
UPDATE_LOCK_TYPE=	LIBNAME option value

Last updated: February 3, 2026