Previous Page | Next Page

SAS/ACCESS Interface to Sybase

Data Set Options for Sybase

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

SAS/ACCESS Data Set Options for Sybase
Option Default Value
AUTOCOMMIT=
LIBNAME option setting
BULK_BUFFER=
100
BULKLOAD=
NO
DBCOMMIT=
LIBNAME setting
DBCONDITION=
none
DBCREATE_TABLE_OPTS=
LIBNAME setting
DBFORCE=
NO
DBGEN_NAME=
LIBNAME option setting
DBINDEX=
LIBNAME option setting
DBKEY=
none
DBLABEL=
NO
DBLINK=
LIBNAME option setting
DBMASTER=
none
DBMAX_TEXT=
LIBNAME option setting
DBNULL=
_ALL_YES
BPROMPT=
LIBNAME option setting
DBSASLABEL=
COMPAT
DBSLICE=
none
DBSLICEPARM=
THREADED_APPS,2 or 3
DBTYPE=
see Data Types for Sybase
ERRLIMIT=
1
NULLCHAR=
SAS
NULLCHARVAL=
a blank character
READBUFF=
LIBNAME option setting
READ_ISOLATION_LEVEL=
LIBNAME option setting
READ_LOCK_TYPE=
LIBNAME option setting
SASDATEFMT=
DATETIME22.3
SCHEMA=
LIBNAME option setting
EGMENT_NAME=
none
UPDATE_ISOLATION_LEVEL=
LIBNAME option setting
UPDATE_LOCK_TYPE=
LIBNAME option setting

Previous Page | Next Page | Top of Page