The LIBNAME Statement for Relational Databases |
Specifies
when the connection to the DBMS occurs.
Default value: |
NO
|
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
|
-
NO
-
specifies that the connection to the DBMS
occurs when the libref is assigned by a LIBNAME statement.
-
YES
-
specifies that the connection to the DBMS
occurs when a table in the DBMS is opened.
The default value of NO is overridden
if DBPROMPT=YES.
The DEFER= option is ignored when CONNECTION=UNIQUE,
because a connection is performed every time a table is opened.
HP Neoview, Microsoft SQL Server, Netezza, ODBC: When you set DEFER=YES, you must also set
the PRESERVE_TAB_NAMES=
and PRESERVE_COL_NAMES= options to the values that you want. Normally, SAS
queries the data source to determine the correct defaults for these options
during LIBNAME assignment, but setting DEFER=YES postpones the connection.
Because these values must be set at the time of LIBNAME assignment, you must
assign them explicitly when you set
DEFER=YES.
CONNECTION= LIBNAME Option
DBPROMPT= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.