Data Set Options for MySQL

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

Option	Default Value
AUTOCOMMIT=	the current LIBNAME option setting
DBCOMMIT=	the current LIBNAME option setting
DBCONDITION=	none
DBCREATE_TABLE_OPTS=	the current LIBNAME option setting
DBGEN_NAME=	DBMS
DBINDEX=	the current LIBNAME option setting
DBKEY=	none
DBLABEL=	NO
DBMASTER=	none
DBMAX_TEXT=	1024
DBNULL=	YES
DBPROMPT=	the current LIBNAME option setting
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for MySQL
DBTYPE=	see LIBNAME Statement Data Conversions
ESCAPE_BACKSLASH=	NO
INSERTBUFF=	0
NULLCHAR=	SAS
NULLCHARVAL=	a blank character
PRESERVE_COL_NAMES=	current LIBNAME option setting
QUALIFIER=	the current LIBNAME option setting
SASDATEFORMAT=	DATETIME20.0
UPDATE_ISOLATION_LEVEL=	the current LIBNAME option setting

Previous Page
|
Next Page
|
Top of Page