Data Set Options for Netezza

All SAS/ACCESS data set options in this table are supported for Netezza. Default values are provided where applicable. For general information about this feature, 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_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 setting
DBCOMMIT=	LIBNAME option setting
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option setting
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	LIBNAME option setting
DBKEY=	none
DBLABEL=	NO
DBMASTER=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBNULLKEYS=	LIBNAME option setting
DBPROMPT=<	LIBNAME option setting
DBSASTYPE=	see Data Types for Netezza
DBTYPE=	see Data Types for Netezza
DISTRIBUTE_ON=	none
ERRLIMIT=	1
IGNORE_READ_ONLY_COLUMNS=	NO
INSERTBUFF=	LIBNAME option setting
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
PRESERVE_COL_NAMES=	LIBNAME option setting
QUALIFIER=	LIBNAME option setting
QUERY_TIMEOUT=	LIBNAME option setting
READBUFF=	LIBNAME option setting
SASDATEFMT=	none
SCHEMA=	LIBNAME option setting