Panels › (DQIG0) Output Row: Column Selection

(DQIG0) Output Row: Column Selection

 =>
 
 --------------------------------------------------------------------------DQIG0
 DATAQUERY: OUTPUT ROW: COLUMN SELECTION         QUERY NAME:
 -------------------------------------------------------------------------------
 Select columns to be included in the output row by placing any character next
 to the desired names.
 -------------------------------------------------------------------------------
 SELECT|TABLE/COLUMN NAME                       |     DESCRIPTION
 -------------------------------------------------------------------------------
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
       |                                        |
 -------------------------------------------------------------------------------
 <PF1> HELP           <PF2> RETURN         <PF3> NOT USED   <PF4> CONTINUE
 <PF5> EXTEND COLUMN  <PF6> DISPLAY QUERY  <PF7> BACKWARD   <PF8> FORWARD

Description

This SQL Mode Guided Query panel allows you to select the columns to include in your output. The display contains the names of all the columns from the primary and secondary tables you selected.

Action

Select one or more columns from the list displayed. Type a character over the underscore beside each column name and press Enter.

Display Fields

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

QUERY NAME:

Name assigned this query with the first Guided panel.

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.

Columns

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

TABLE NAME/ COLUMN NAME

Names of the columns you selected for use, including table names.

DESCRIPTION

Datadictionary description of each column you selected for use in structuring your calculation.

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

Exits the 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.