Panels › (DQHQ0) Multiple Occurrence Selection

(DQHQ0) Multiple Occurrence Selection

 =>
 
 --------------------------------------------------------------------------DQHQ0
 DATAQUERY:  MULTIPLE OCCURRENCE SELECTION          QUERY NAME: _______________
 -------------------------------------------------------------------------------
 The column you have selected has multiple occurrences.  You may select the
 individual occurrences to be displayed on the report by placing the occurrence
 numbers in the fields provided below.
 -------------------------------------------------------------------------------
   TABLE NAME:                                     COLUMN LENGTH:
   COLUMN NAME:                                    COLUMN TYPE  :
   DESCRIPTION:
   NUMBER OF OCCURRENCES:
 -------------------------------------------------------------------------------
 
 
 
 
 
 
 
 
 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2> RETURN        <PF3> NOT USED      <PF4>  CONTINUE

Description

In DQL Mode, the Guided Query Multiple Occurrence Selection panel appears for each column selected during Guided Query creation that is a repeating column.

Action

Type numbers of the occurrences you want to use in the columns indicated by cursor position. Press the Tab key to move the cursor from one column to the next. The number of columns available for entry equals the number of occurrences shown in the NUMBER OF OCCURRENCES display, to a maximum of 96. Press <PF4> CONTINUE or Enter 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.

TABLE NAME:

Name of table containing the repeating column.

COLUMN NAME:

Name of the repeating column whose occurrences you are to select for the report.

DESCRIPTION:

Datadictionary description of the column.

NUMBER OF OCCURRENCES:

Total number of occurrences of the named column.

COLUMN LENGTH:

Number of positions in the column.

COLUMN TYPE:

One of the following:

C

Character

N

Numeric

S

Short floating-point

L

Long floating-point

E

Extended floating-point

Y

Double character

Z

Double character mixed

K

Kanji

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

Exits the current panel.

<PF4> CONTINUE

Goes to the next Guided Query Creation function panel.