Panels › (DQHK0) Report Column Heading Definition

(DQHK0) Report Column Heading Definition

 =>
 
 --------------------------------------------------------------------------DQHK0
 DATAQUERY:  REPORT COLUMN HEADING DEFINITION    QUERY NAME: _______________
 -------------------------------------------------------------------------------
 You may enter alternate headings for any column on the report.
 Defaults are provided and can be modified.
 -------------------------------------------------------------------------------
 COLUMN:                                 LINE1:
 TABLE :                                 LINE2:
 
 COLUMN:                                 LINE1:
 TABLE :                                 LINE2:
 
 COLUMN:                                 LINE1:
 TABLE :                                 LINE2:
 
 COLUMN:                                 LINE1:
 TABLE :                                 LINE2:
 
 COLUMN:                                 LINE1:
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

In DQL Mode, the optional Guided Query Report Column Heading Definition panel lets you define your own titles for each column or key printed in your query output. If you do not define a title, CA Dataquery supplies one using the Datadictionary alternate heading.

If no Datadictionary alternate heading exists, the column name is used. The default names are shown in the LINE1: input columns for each column selected for the report.

Action

Enter a one or two line title for each column heading in the columns provided for each column. Type over the default column names, or 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:

Name you assigned this query.

COLUMN:

Each COLUMN display column contains the name of a key or column you selected to appear in the report. Temporary results are not shown since you assign them a name yourself when you create them.

TABLE:

Each TABLE display column contains the table name of the key or column paired with it in the COLUMN display column. If it is a temporary result, no table name is listed. Instead, you see the legend temporary result.

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 Column Definition (DQHI0) 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 position.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous panel, if any.

<PF8> FORWARD

Displays next panel, if any.