The LIBNAME Statement for Relational Databases DEFER= LIBNAME Option 97
libname dblib oracle user=scott password=tiger dbsliceparm=ALL;
The following code demonstrates how to use DBSLICEPARM= as a table level option
to turn on threaded reads for this particular table, requesting up to four connections:
proc reg SIMPLE;
data=dblib.customers (dbsliceparm=(all,4));
var age weight;
where years_active>1;
run;
See Also
“DBSLICEPARM= Data Set Option” on page 188
DEFER= LIBNAME Option
Specifies when the connection to the DBMS occurs
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support: DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle,
Microsoft SQL Server, SYBASE, Teradata
Default value: NO
Syntax
DEFER= NO | YES
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.
ODBC and Microsoft SQL Server Details: When you set DEFER=YES, you must also
set the PRESERVE_TAB_NAMES= and PRESERVE_COL_NAMES= options to their
desired values. 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.
