Data Set Options for SAP IQ

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

SAS/ACCESS Data Set Options for SAP IQ
Option	Default Value
BL_CLIENT_DATAFILE=	none
BL_COLUMN_DELIMITER=	\| (pipe symbol) Alias is BL_DELIMTER=.
BL_DATAFILE=	When BL_USE_PIPE=NO, creates a file in the current directory or with the default file specifications.
BL_DELETE_DATAFILE=	YES (only when BL_USE_PIPE=NO)
BL_OPTIONS=	none
BL_ROW_DELIMITER=	\x0A\x02\x0A (line feed, Control-B, line feed)
BL_SERVER_DATAFILE=	creates a data file in the current directory or with the default file specifications (same as for BL_DATAFILE=)
BL_USE_PIPE=	YES
BULKLOAD=	NO
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=	YES
DBNULLKEYS=	LIBNAME option value
DBPROMPT=<	LIBNAME option value
DBSASTYPE=	see Data Types for SAP IQ
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,2 or THREADED_APPS,3
DBTYPE=	see Data Types for SAP IQ
ERRLIMIT=	1
IGNORE_READ_ONLY_COLUMNS=	NO
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

Last updated: February 3, 2026