SAS/ACCESS Interface to Greenplum

Data Set Options for Greenplum

All SAS/ACCESS data set options in this table are supported for Greenplum. Default values are provided where applicable. For details about this feature, see Overview.

SAS/ACCESS Data Set Options for Greenplum
Option	Default Value
BL_DATAFILE=	none
BL_DELETE_DATAFILE=	none
BL_DELIMITER=	\|
BL_ENCODING=	DEFAULT
BL_ESCAPE=	\
BL_EXCEPTION=	none
BL_EXECUTE_CMD=	none
BL_EXECUTE_LOCATION=	none
BL_EXTERNAL_WEB=
BL_FORCE_NOT_NULL=	none
BL_FORMAT=	TEXT
BL_HEADER=	NO
BL_HOST=	127.0.0.1
BL_NULL=	'\N' [TEXT mode], unquoted empty value [CSV mode]
BL_PORT=	8080
BL_PROTOCOL=	'gpfdist'
BL_QUOTE=	" (double quotation mark)
BL_REJECT_LIMIT=	none
BL_REJECT_TYPE=	ROWS
BULKLOAD=	none
DBCOMMIT=	LIBNAME option setting
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option setting
DBFORCE=	none
DBGEN_NAME=	DBMS
DBINDEX=	LIBNAME option setting
DBKEY=	none
DBLABEL=	none
DBMASTER=	none
DBMAX_TEXT=	1024
DBNULL=	none
DBNULLKEYS=	LIBNAME option setting
DBPROMPT=	LIBNAME option setting
DBSASTYPE=	see Data Types for Greenplum
DBTYPE=	see Data Types for Greenplum
DISTRIBUTED_BY=	DISTRIBUTED_RANDOMLY
ERRLIMIT=	1
IGNORE_ READ_ONLY_COLUMNS=	none
INSERTBUFF=	LIBNAME option setting
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
PRESERVE_COL_NAMES=	LIBNAME option setting
QUERY_TIMEOUT=	LIBNAME option setting
READBUFF=	LIBNAME option setting
SASDATEFMT=	none
SCHEMA=	LIBNAME option setting

Top of Page