The LIBNAME Statement for Relational Databases

DEFER= LIBNAME Option

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

Syntax
Syntax Description
Details
See Also

Syntax

DEFER=YES| NO

Syntax Description

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.

Details

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.