The LIBNAME Statement for Relational Databases |
Specifies
a user-defined initialization command to execute once
within the scope of the LIBNAME statement or libref that established the first
connection to the DBMS.
Default value: |
none
|
Valid in: |
SAS/ACCESS LIBNAME
statement
|
DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, DB2 under z/OS,
Greenplum, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC,
OLE DB, Oracle, Sybase, Sybase IQ, Teradata
|
DBLIBINIT=<'>DBMS-user-command<'>
|
-
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.
The initialization command that you select
can be a script, stored procedure, or any DBMS SQL statement that might provide
additional control over the interaction between your SAS/ACCESS interface
and the DBMS.
The command executes immediately after the first DBMS
connection is successfully established. If the command fails, then a disconnect
occurs and the libref is not assigned. You must specify the command as a single,
quoted string, unless it is an environment variable.
DBLIBINIT= fails if either CONNECTION=UNIQUE or DEFER=YES,
or if both of these LIBNAME options are specified.
When multiple LIBNAME statements share a connection,
the initialization command executes only for the first LIBNAME statement,
immediately after the DBMS connection is established. (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.)
In the following example, CONNECTION=GLOBALREAD is specified
in both LIBNAME statements, but the DBLIBINIT commands are different. Therefore,
the second LIBNAME statement fails to share the same physical connection.
libname mydblib oracle user=testuser pass=testpass
connection=globalread dblibinit='Test';
libname mydblib2 oracle user=testuser pass=testpass
connection=globalread dblibinit='NoTest';
CONNECTION= LIBNAME Option
DBLIBTERM= LIBNAME Option
DEFER= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.