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
Example 1: Use the Default Value (No Prompt)
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.
In the next example,
the DBPROMPT window appears 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.