Step 3—Specifying MVS driving object
File-AID/RDX displays the following figure when you select Option 2 from the File-AID/RDX Primary Option Menu and your profile specifies DB2 as the default object type.
Extract - DB2 Driving Object
File-AID/RDX ----------------- 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 **
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 **
Select the object type of the driving object for the extract: | |
|---|---|
In this field… | Do the following: |
Command | Type MVS to switch to the Extract - MVS Driving Object screen as soon as you complete specifying the selection criteria for the driving table. |
Press Enter | File-AID/RDX displays the Extract - MVS Driving Object screen, where you specify an MVS file as the driving object for the request. |
Field Names and Descriptions
For descriptions of the field names and primary commands, see Field Names and Descriptions.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*