The LIBNAME Statement for Relational Databases DBLINK= LIBNAME Option 91
Syntax Description
DBMS-user-command
is any DBMS command that can be executed by the SAS/ACCESS engine and that
does not return a result set or output parameters.
Details
The termination command that you select can be a script, stored procedure, or any
DBMS SQL statement that might provide additional control over the interaction
between the SAS/ACCESS engine and the DBMS. The command executes immediately
before SAS terminates the last connection to the DBMS. If the command fails, then
SAS provides a warning message but the library deassignment and disconnect still
occurs. You must specify the command as a single, quoted string.
DBLIBTERM= fails if either CONNECTION=UNIQUE or DEFER=YES or both of
these LIBNAME options are specified.
When two LIBNAME statements share the same physical connection, the
termination command is executed only once. (Multiple LIBNAME statements that use
CONNECTION=GLOBALREAD and identical values for CONNECTION_GROUP=,
DBCONINIT=, DBCONTERM=, DBLIBINIT=, and DBLIBTERM= options and any
DBMS connection options can share the same connection to the DBMS.)
Example
In the following example, CONNECTION=GLOBALREAD is specified on both
LIBNAME statements, but the DBLIBTERM commands are different. Therefore, the
second LIBNAME statement fails to share the same physical connection.
libname mydblib oracle user=testuser pass=testpass
connection=globalread dblibterm=’Test’;
libname mydblib2 oracle user=testuser pass=testpass
connection=globalread dblibterm=’NoTest’;
See Also
“DBLIBINIT= LIBNAME Option” on page 89
DBLINK= LIBNAME Option
Specifies a link from your local database to database objects on another server (in the Oracle
interface); specifies a link from your default database to another database on the server to which
you are connected (in the SYBASE interface)
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: Oracle, SYBASE
Default value: none
Syntax
DBLINK=database-link
