DB2 graphic  QMF Version 8

On a prompt panel

QMF displays a command prompt panel if you enter a command with a syntactical error or a misspelling twice in succession, or when you enter the command name followed by a question mark on the command line. This prompt panel is useful when entering long commands.

For example, when you enter RUN ? the following command prompt panel is displayed on which you can enter the required information:

Figure 1. RUN Command prompt panel

DXYEPRUN                 RUN Command Prompt
                                                                        1 to 8 of 8
 Type (                        )
 Name (<------------------------------------------------->)+
 .... (<------------------------------------------------->)+
 .... (<------------------------------------------------->)+
 .... (<------------------------------------------------->)+
 .... (<------------------------------------------------->)+
 .... (<------------------------------------------------->)+
      To run an object from temporary storage, enter its type:
      QUERY or PROC.
      To run an object from the database, enter its name (and
      optionally its type). Type can be QUERY or PROC.

 F1=Help   F3=End   F4=List   F7=Backward   F8=Forward

If QMF needs additional information to complete a command, a second panel prompts you for command parameters.

You can skip the first panel of this two-step prompt by entering the command, the object type, and the object name, followed by a question mark on the command line. A panel appears containing the parameters that are applicable to that object.

A question mark is not valid in the parameters portion of a command (after the left parenthesis). Also, any parameters following the question mark are ignored. For example, (FORM=FORM2 is ignored in the following command:

RUN QUERY MYQUERY? (FORM=FORM2

These three function keys are contained on most prompt panels:

Help
Displays help information about the message being displayed at the bottom of the screen
List
Displays a list of objects from which you can select
End
Returns to the panel from which the prompt was issued

Long names support in Version 8.1

In DB2 QMF Version 8.1, many commands now support long owner and table names. The name option of these commands has been expanded to receive long names for the table reference "Location.Owner.Name" where Owner and Name can now be long names (128 characters each). The object name on these commands has been increased from 50 to 280 bytes. This will accommodate an object name of the form "location(16)"."authid(128)"."object name(128)". Here is an example of how the command prompt screen has been updated for long names support:

Figure 2. Command prompt screen updated for long names support

DXYEPERA                     ERASE Command Prompt
                                                                1 to 15 of 20
 Type      (                     )
           Enter the type of the object to be erased from the database:
           QUERY, PROC, FORM, or TABLE. (This is opitonal.)

 Name      (<--------------------------------------->)+
 ....      (<--------------------------------------->)+
 ....      (<--------------------------------------->)+
 ....      (<--------------------------------------->)+
 ....      (<--------------------------------------->)+
 ....      (<--------------------------------------->)+
           Enter the name of the object to be erased from the database.

 Confirm  ( YES     )
          Display the confirmaiton panel before erasing the object 
          from the database?  YES or NO.

          REMINDER: USE THIS COMMAND WITH CAUTION.
          The ERASE command will permanently remove the object
          named above.

 F1=Help   F3=End   F4=List   F7=Backward   F8=Forward


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004