DBPROMPT=

DBPROMPT=

Specifies whether SAS displays a window that prompts the user to enter DBMS connection information.

Default value: NO

Syntax
Details

Syntax

DBPROMPT=YES | NO

YES: causes SAS to display the prompting window.
NO: does not cause SAS to display the prompting window.

Details

As a data set option, DBPROMPT= is supported only for view descriptors.

Note: DBPROMPT= is not supported in DB2 under OS/390. [cautionend]

In the following example, connection options are 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=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. The user must edit or accept the connection information in the DBPROMPT window to proceed.

proc print data=myview(dbprompt=yes);
run;

Chapter Contents
Previous
Next
Top of Page