DB2 graphic  QMF Version 8

Prompted query

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.

Long table names

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)".

Figure 12. Tables panel

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.

Figure 13. Table List panel

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.


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