94 DBPROMPT= LIBNAME Option Chapter 9
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 UNIX/PC, Informix, ODBC, Oracle, Microsoft SQL Server,
SYBASE, Teradata
Default value:
NO
Syntax
DBPROMPT=YES | NO
Syntax Description
YES
specifies that SAS displays a window that interactively prompts you for the DBMS
connection options the first time the libref is used.
NO
specifies that SAS does not display the prompting window.
Details
If you specify DBPROMPT=YES, it is not necessary to provide connection options with
the LIBNAME statement. If you do specify connection options with the LIBNAME
statement and you specify DBPROMPT=YES, then the connection option values are
displayed in the window (except for the password value, which appears as a series of
asterisks). All of these values can be overridden interactively.
The DBPROMPT= option interacts with the DEFER= option to determine when the
prompt window appears. If DEFER=NO, the DBPROMPT window opens when the
LIBNAME statement is executed. If DEFER=YES, the DBPROMPT window opens the
first time a table or view is opened. The DEFER= option normally defaults to NO but
defaults to YES if DBPROMPT=YES. You can override this default by explicitly setting
DEFER=NO.
The DBPROMPT window usually opens only once for each time that the LIBNAME
statement is specified. It might open multiple times if DEFER=YES and the connection
fails when SAS tries to open a table. In these cases, the DBPROMPT window opens
until a successful connection occurs or the user selects
Cancel .
The maximum password length for most of the SAS/ACCESS LIBNAME interfaces is
32 characters.
Oracle Details: You can enter 30 characters for the USERNAME and PASSWORD
and up to 70 characters for the PATH, depending on your platform.
Teradata Details: You can enter up to 30 characters for the USERNAME and
PASSWORD.
Examples
In the following example, the DBPROMPT window does not open when the
LIBNAME statement is submitted because DEFER=YES. The DBPROMPT window
opens when the PRINT procedure is processed, a connection is made, and the table is
opened.
libname mydblib oracle dbprompt=yes
defer=yes;
