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:
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:
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:
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