Panels › (DQHG0) Report Column Definition

(DQHG0) Report Column Definition

 =>
 
 --------------------------------------------------------------------------DQHG0
 DATAQUERY:  REPORT COLUMN DEFINITION          QUERY NAME:
 -------------------------------------------------------------------------------
 Select the keys or columns to be included on the report by placing any
 character next to the desired names.
 -------------------------------------------------------------------------------
 SELECT|TABLE/KEY(*) OR COLUMN NAME             |     DESCRIPTION
 -------------------------------------------------------------------------------
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

In DQL Mode, the required Guided Query Report Column Definition panel allows you to choose a number of the keys and columns from the tables you selected for your query, depending on how complex your query has become.

If you plan to create your own titles and reformat numeric data in a later step, your query could become quite lengthy and exceed the maximum line limit of the Editor established at your site. (See your CA Dataquery Administrator regarding line limits.)

If you have displayed your query with each step, you have an idea of how many lines it occupies. The contents of each key or column selected, including temporary result columns, can be printed on the report. An introduction to this panel appears in the CA Dataquery User Guide.

Action

Select at least one key or column whose values are to print on the query output. Enter any character in the Select column next to your selection or selections and press Enter or <PF4> CONTINUE to go on to the next panel.

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

QUERY NAME:

The name you assigned this query.

Columns

Refer to the following for a discussion of each column on this panel.

TABLE/KEY(*) OR COLUMN NAME

Lists all columns and keys in tables chosen along with table names.

DESCRIPTION

Datadictionary description of each key and column listed, if descriptions are defined.

Entry Fields

Refer to the following chart for valid entries in the fields on this panel. Use the Tab and arrow keys to move the cursor. To change an entry, write or space over it. When entries are complete, press Enter or a valid PF key.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP

Displays Help information about the current panel.

<PF2> RETURN

Returns to Report Definition (DQHF0) panel.

<PF4> CONTINUE

Displays the next Guided Query panel when this one is complete. (Returning to this panel from a later panel will require that you redisplay any entry to save it again.)

<PF5> EXTEND COLUMN

Displays the extended column definition for key/column selected by cursor.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.