Step 4—Selecting columns to extract
The Object Selection Criteria screen illustrated in the following figure displays when you END out of the Delimited Format Options Screen. Use this screen to identify the columns to extract, indicate the order and direction of the columns, and to provide selection criteria for extraction of specific rows of data.
Object Selection Criteria
Command ===> SCROLL ===> CSR
Specify selective column and selection criteria for table FRSAMP.ORDER_TABLE
SEL Column Name Type(Length) Order (A/D) Where More: >
--- - -------------------- ------------ ----- ----- ----+---10----+---20--
___ P ORDER_NUMBER CHAR(6) ___
___ CUST_NUM CHAR(6) ___
___ 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: |
SEL | Type S for columns ORDER_NUMBER, CUST_NUM, ORD_DATE, ORD_AMOUNT, and ORD_DESCRIPTION. |
Order | Leave blank to accept the default. |
(A/D) | Leave blank to accept the default. |
Where | Type = ‘CW3375’ for column CUST_NUM. |
Command | Type the END primary command. |
Press Enter | File-AID/RDX displays the Create New File screen to specify the file attributes for the new delimited extract file FRSAMP.DELIMEXT. |
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.