Data Set Options for Relational Databases |
Specifies
whether SAS displays a window that prompts you to enter
DBMS connection information.
Default value: |
NO
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Aster nCluster, Greenplum,
HP Neoview, MySQL, Netezza, Oracle, Sybase, Sybase IQ
|
-
YES
-
displays the prompting window.
-
NO
-
does not display the prompting window.
This data set option is supported only
for view descriptors.
Oracle: In the Oracle interface, you can
enter 30 characters each for USERNAME and PASSWORD and up to 70 characters
for PATH, depending on your platform and terminal type.
In this example, connection information is specified
in the ACCESS procedure. The DBPROMPT= data set option defaults to NO during
the PRINT procedure because it is not specified.
proc access dbms=oracle;
create alib.mydesc.access;
user=testuser;
password=testpass;
table=dept;
create vlib.myview.view;
select all;
run;
proc print data=vlib.myview;
run;
In the next example, the DBPROMPT window opens during
connection to the DBMS. Values that were previously specified during the creation
of MYVIEW are pulled into the DBPROMPT window fields. You must edit or accept
the connection information in the DBPROMPT window to proceed. The password
value appears as a series of asterisks; you can edit it.
proc print data=vlib.myview(dbprompt=yes);
run;
To assign this option to a group of relational
DBMS tables or views, see the DBPROMPT= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.