Data Set Options for Netezza

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

SAS/ACCESS Data Set Options for Netezza
Option	Default Value
BL_DATAFILE=	When BL_USE_PIPE=NO, creates a file in the current directory or with the default file specifications.
BL_DEFAULT_DIR=	temporary file directory that is specified by the UTILLOC= system option
BL_DELETE_DATAFILE=	YES (only when BL_USE_PIPE=NO)
BL_DELIMITER=	\| (the pipe symbol)
BL_OPTIONS=	none
BL_USE_PIPE=	YES
BULKLOAD=	NO
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
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASTYPE=	see Data Types for Netezza
DBTYPE=	see Data Types for Netezza
DISTRIBUTE_ON=	none
ERRLIMIT=	1
IGNORE_READ_ONLY_COLUMNS=	NO
INSERT_SQL=	LIBNAME option value
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
QUALIFIER=	LIBNAME option value
QUERY_TIMEOUT=	LIBNAME option value
READBUFF=	LIBNAME option value
SASDATEFMT=	none
SCHEMA=	LIBNAME option value
SUB_CHAR=	none

Last updated: February 3, 2026