Panels › (DQIA0) Define Expression: Select Columns

(DQIA0) Define Expression: Select Columns

 =>
 
 --------------------------------------------------------------------------DQIA0
 DATAQUERY: DEFINE EXPRESSION: SELECT COLUMNS     QUERY NAME: _______________
 -------------------------------------------------------------------------------
 Select any columns you wish to use in calculating the value of:
 Expression  01.
 Place any character next to the desired column names.
 -------------------------------------------------------------------------------
 SELECT|  TABLE NAME/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 helps you select columns for use in defining an expression for your query. Completion of the Define Expression: Select Columns panel is not required for each Result named. Use it only if your arithmetic expression will include data found during query execution in a column. With it, you tell CA Dataquery which columns you will use in an arithmetic expression to create the results you want. You can use up to ten columns. You will also be allowed to include literal values in your calculation.

Action

Select a column from the list of numeric columns for the tables you selected that you want to be used in defining an arithmetic expression by placing a character in the select column next to the column names. Press Enter or <PF4> CONTINUE to go to the next panel.

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

Numeric fields referenced in the query that can be used in the calculation that defines the temporary result column contents.

DESCRIPTION

The Datadictionary description of each column listed.

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 Define Temporary Result Columns (DQH90) 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.

<PF6> DISPLAY QUERY

Displays the query created so far.

<PF7> BACKWARD

Displays a previous screen, if any.

<PF8> FORWARD

Displays next screen, if any.