Data Set Options for Informix

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

SAS/ACCESS Data Set Options for Informix
Option	Default Value
BL_DATAFILE=	none
BL_DBACCESS_PATH=	none
BL_DEFAULT_DIR=	temporary-file-directory that is specified by the UTILLOC= system option
BL_DELETE_DATAFILE=	YES
BL_DELIMITER=	pipe symbol (\|)
BL_INFORMIXDIR=	LIBNAME option value
BL_LOAD_METHOD=	APPEND
BL_LOGFILE=	none
BULKLOAD=	LIBNAME option value
BULKUNLOAD=	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
DBNULL=	_ALL_=YES
DBNULLKEYS=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for Informix
DBSLICE=	none
DBSLICEPARM=	THREADED_APPS,2 or 3
DBSLICEPARM=	see Data Types for Informix
ERRLIMIT=	1
INSERTBUFF=	LIBNAME option value
LOCKTABLE=	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
READBUFF=	LIBNAME option value
SASDATEFMT=	DATETIME
SCHEMA=	LIBNAME option value

Last updated: February 3, 2026