Data Set Options for Relational Databases

DBPROMPT= Data Set Option

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

Syntax
Syntax Description
Details
Examples
See Also

Syntax

DBPROMPT=YES | NO

Syntax Description

YES: displays the prompting window.
NO: does not display the prompting window.

Details

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.

Examples

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;