Data Set Options for JDBC

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

SAS/ACCESS Data Set Options for JDBC
Option	Default Value
BULKLOAD=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBMAX_TEXT_TYPES=	LONG
DBNULLWHERE=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for JDBC
DBTYPE=	see Data Types for JDBC
INSERTBUFF=	LIBNAME option value
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
READBUFF=	LIBNAME option value
SASDATEFMT=	see Data Types for Spark
SCHEMA=	LIBNAME option value
SUB_CHAR=	none
TRANSCODE_FAIL=	LIBNAME option value

Last updated: February 3, 2026