The LIBNAME Statement for Relational Databases DBSLICEPARM= LIBNAME Option 95
proc print data=mydblib.staff;
run;
In the following example, the DBPROMPT window opens while the LIBNAME
statement is processing. The DBPROMPT window does not open in subsequent
statements because the DBPROMPT window opens only once per LIBNAME.
libname mydblib oracle dbprompt=yes
defer=no;
In the following example, values provided in the LIBNAME statement are pulled into
the DBPROMPT window. The values
testuser
and ABC_server
appear in the
DBPROMPT window and can be edited and confirmed by the user. The password value
appears in the DBPROMPT window as a series of asterisks; it can also be edited by the
user.
libname mydblib oracle
user=testuser pw=testpass
path=’ABC_server’ dbprompt=yes defer=no;
See Also
To apply this option to a view descriptor, see the data set option “DBPROMPT= Data
Set Option” on page 184.
DBSLICEPARM= LIBNAME Option
Controls the scope of DBMS threaded reads and the number of threads
Valid in:
SAS configuration file option, SAS invocation option, global SAS option,
LIBNAME option, or dataset option
DBMS support: DB2 UNIX/PC, ODBC, Oracle, SYBASE, Teradata
Default value: THREADED_APPS,2 (Oracle,Teradata,) THREADED_APPS,3 (DB2 UNIX/
PC, ODBC, SYBASE)
Syntax
DBSLICEPARM=NONE | THREADED_APPS |ALL
DBSLICEPARM=( NONE | THREADED_APPS |ALL <, max-threads>)
Syntax Description
Two syntax diagrams are shown here in order to highlight the simpler version. In
most cases, the simpler version suffices.
NONE
disables DBMS threaded read. SAS reads tables on a single DBMS connection,
identically to SAS Version 8.
