Step 2—Specifying driving table selection criteria
The following figure is displayed when you enter Yes in the Edit Object Selection Criteria field on the Extract - DB2 Driving Object screen.
Driving Object Selection Criteria
Command ===> END SCROLL ===> CSR
Specify selection criteria for table FRSAMP.ORDER_TABLE
Column Name Type(Length) Where More: >
- -------------------- ------------------ ----+---10----+---20----+---30---
P ORDER_NUMBER CHAR(6)
CUST_NUM CHAR(6) ='CW3375'
SOC_SEC_NUM CHAR(11)
CREDIT_CARD_NUM CHAR(16)
ORD_TYPE CHAR(8)
ORD_DATE DATE
ORD_STAT CHAR(8)
ORD_AMOUNT DEC(9,2)
ORD_DEPOSIT DEC(9,2)
ORD_LINE_COUNT INTEGER
SHIP_CODE CHAR(2)
SHIP_DATE DATE
ORD_DESCRIPTION VCHAR(100)
** End of Columns **
To specify the driving table selection criteria: | |
|---|---|
In this field… | Do the following: |
Where | Type = ‘CW3375’ for column CUST_NUM |
Command | Type the END primary command. |
Press Enter | File-AID/RDX submits the extract job (remember you entered GO in the Extract - DB2 Driving Object screen) and returns to the Primary Option Menu. When the extract is completed you will receive a message with a completion code. You can then preform a load or delete using the resulting extract file. You must use the NEW command in the Load or Delete Reference List to access the extract file as extract files from a Single Panel extract are not placed into the reference lists (see also NEW (N)). |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
Key/Index Indicator | (Untitled 1 byte field) Indicates P Primary key, F Foreign Key, or I High Order Index key (if not Primary or Foreign) for the column as an aid for users to create SQL that will perform well. |
Column Name | Displays the names of the columns of the driving object. |
Type(Length) | Indicates the data type of each column in the driving object. |
Where | Identifies the operators and values to use to further define the extract selection criteria. |
Primary Commands
The following list identifies the primary commands that are available from this screen. For details on the command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
|---|---|
CAPS ON | Switches all entered letters in the WHERE field to uppercase letters. |
CAPS OFF | Does not switch lowercase letters in the WHERE field to uppercase. |
DOWN | Scrolls toward the end of the column list by the specified scroll amount. |
END | Redisplays the Extract - DB2 Driving Object screen. |
LEFT | Scrolls toward the left of the Where column by the specified scroll amount. |
RIGHT | Scrolls toward the right of the Where column by the specified scroll amount. |
SQL | Displays the ISPF/PDF EDIT screen where you can edit or specify selection criteria using SQL syntax. |
UDTSWAP (UDTS) | Swaps the display for distinct type columns from UDT name to the built-in data type and length and vice versa. There are no operands associated with this command. |
UDTTYPE (UDT) | Lists all distinct data types (UDTs) that are part of the extract. The list displays the schema, UDT name, and the built-in data type and length. There are no operands associated with this command. |
UP | Scrolls toward the top of the column list by the specified scroll amount. |
Line Commands
There are no line commands associated with this screen.
Related topics