 |
|
| 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.
| 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 |
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.