Previous Page | Next Page

SAS/ACCESS Interface to Microsoft SQL Server

Data Set Options for Microsoft SQL Server

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

SAS/ACCESS Data Set Options for Microsoft SQL Server
Option Default Value
CURSOR_TYPE=
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
DBSASLABEL=
COMPAT
DBSASTYPE=
see Data Types for Microsoft SQL Server
DBSLICE=
none
DBSLICEPARM=
THREADED_APPS,2 or 3
DBTYPE=
see Data Types for Microsoft SQL Server
ERRLIMIT=
1
IGNORE_ READ_ONLY_COLUMNS=
NO
INSERT_SQL=
LIBNAME option setting
INSERTBUFF=
LIBNAME option setting
KEYSET_SIZE=
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
READ_ISOLATION_LEVEL=
LIBNAME option setting
READ_LOCK_TYPE=
LIBNAME option setting
SASDATEFMT=
none
SCHEMA=
LIBNAME option setting
UPDATE_ISOLATION_LEVEL=
LIBNAME option setting
UPDATE_LOCK_TYPE=
LIBNAME option setting
UPDATE_SQL=
LIBNAME option setting

Previous Page | Next Page | Top of Page