Prompted Query prompts you step by step to build a query. To start Prompted Query, specify LANGUAGE=PROMPTED on a SET PROFILE or RESET QUERY command.
When you begin working with a new prompted query, QMF displays a dialog panel on the right side of the screen to guide you through creating a query. As you work with the dialog panels, the prompted query is built in the echo area on the left side of the screen.
For detailed scenarios of the process of creating queries with Prompted Query, see Using DB2 QMF. Online help is also available.
In DB2 QMF Version 8.1, prompted query supports long table and column names. This is illustrated in the Tables and Table List panels below. When you issue a RESET QUERY (LANGUAGE=PROMPTED) or select the TABLES screen from the DXYEQPSPEC Specify panel, the TABLES prompt screen is presented. You can type the name of the table, or get a list of tables to choose from. A new PF key, PF5- SHOW FIELD, has been added to allow for the entry of long names. A long name entry can be up to 280 characters and has the form of: "location(16)"."authid(128)"."object name(128)".
PROMPTED QUERY LINE 1 Tables: DXYEQPTABLE Tables > ... Type one or more table names. 1 to 7 of 15 *** END *** (Q.STAFF89012345678901234567890123456789012345678901234567890 > ( ) ( ) ( ) ( ) ( ) ( ) F1=Help F4=List F5=Show Field F7=Backward F8=Forward F12=Cancel OK, ENTER performed. Please proceed.
If a long table name is entered on the Show Table Name panel after PF5 Show Field key is entered, press ENTER on the Show Table Name panel returns back to the Tables panel with a ">" sign placed at the position where the right parenthesis used to be.
The Table List panel is displayed when the PF4 List key is pressed on the Tables panel. If the name is longer than 18 characters, a ">" sign is placed at the end of the name. If the owner is longer than 8 characters, a ">" sign is placed at the end of the owner.
DXYEOBLIMU Table List Name Owner 1 to 10 of 174 T2045678901234567> LLK1067> APPLICANT Q COMMAND_SYN_CMS Q COMMAND_SYN_TSO Q DSQ_RESERVED Q F1=Help F5=Describe F7=Backward F8=Forward F10=Comments F11=sort F12=Cancel
When a long table name is selected from the Table List panel, it returns back to the Tables panel with a ">" sign placed at the position where the right parenthesis used to be.