DBMS Access Using the LIBNAME Statement (3)

Accessing Other Vendors' DBMS Data

DBMS Access Using the LIBNAME Statement

LIBNAME Options

SAS/ACCESS LIBNAME options are options that apply to the processing of objects and data in a DBMS, such as its tables or indexes. For example, specifying ACCESS=READONLY prevents writing to the DBMS. When you specify a SAS/ACCESS LIBNAME option, the option is applied to all objects (such as tables and views) in the database that the libref represents.

Support for many SAS/ACCESS LIBNAME options is DBMS specific. See "SAS/ACCESS Software: DBMS-Specific Information" in SAS/ACCESS Software for Relational Databases to learn more.

The following table lists several common SAS/ACCESS LIBNAME options. You may also wish to read descriptions of these options. To learn about more advanced options, see SAS/ACCESS Software for Relational Databases.

ACCESS=		DBPROMPT=
CONNECTION=		PRESERVE_COL_NAMES=
CONNECTION_GROUP=		PRESERVE_TAB_NAMES=
DBCONINIT=		READ_LOCK_TYPE=
DBCONTERM=		REREAD_EXPOSURE=
DBINDEX=		SCHEMA=
DBLIBINIT=		SPOOL=
DBLIBTERM=		UPDATE_LOCK_TYPE=

Example

In the statement below, the SAS/ACCESS LIBNAME options ensure that multiple librefs share a single connection, that the ODBC database indexes are used, and that the user-defined initialization command EXEC UPDATE_PROC is submitted immediately after connection:

     libname dbdeux odbc
             user=cestmoi using=sesame db=receipts
             connection=globalread dbindex=yes
             dbconinit='exec update_proc';