Reviewing the cascading EXCLUDE and ALL
After entering the A and X line commands and pressing the Enter key, File-AID/RDX redisplays the Extract Scope - Object View screen as shown in the following figure.
Notice that other related objects have been excluded because of excluding ‘TSOID01.FRSAMP.CUSTOMER’ and selecting ALL for ‘TSOID01.FRSAMP.CUSTOMER’.
Extract Scope - Object View with Cascading EXCLUDE
File-AID/RDX ------- Extract Scope - Object View -------------- Row 1 from 12
Command ===> NAV Scroll ===> PAGE
Primary Commands: EXclude/Unex, Change, Find, Hide, VIew, CHEck, SIze, REPort
Line Commands: X = Exclude A = All R = Relationship View
U = Unexclude P = Passthru
Driving Object: FRSAMP.ORDER_TABLE
SSID: DSN Location: DSNLOCAT Sampling Criteria
Object Name Cycle MaxRow Nth Status
---------------------------------------------- ----- ------ --- ----------
_ FRSAMP CONTACT_TABLE * * *
_ FRSAMP CUSTOMER_TABLE * * *
_ FRSAMP ORDER_LINE_TABLE * * 2
_ FRSAMP ORDER_TABLE * * *
_ FRSAMP PART_TABLE * * *
_ FRSAMP SUPPLIER_TABLE * 4 *
_ 'TSOID01.FRSAMP.CONTACTT' * * * Excl Scope
_ 'TSOID01.FRSAMP.CUSTOMER' * * * Excl User
_ 'TSOID01.FRSAMP.ORDERLIN' * * * Excl Scope
_ 'TSOID01.FRSAMP.ORDERTAB' * * * Excl Scope
_ 'TSOID01.FRSAMP.PARTTABL' * * * All
_ 'TSOID01.FRSAMP.SUPPLIER' * * *
******************************* Bottom of data ********************************
Command ===> NAV Scroll ===> PAGE
Primary Commands: EXclude/Unex, Change, Find, Hide, VIew, CHEck, SIze, REPort
Line Commands: X = Exclude A = All R = Relationship View
U = Unexclude P = Passthru
Driving Object: FRSAMP.ORDER_TABLE
SSID: DSN Location: DSNLOCAT Sampling Criteria
Object Name Cycle MaxRow Nth Status
---------------------------------------------- ----- ------ --- ----------
_ FRSAMP CONTACT_TABLE * * *
_ FRSAMP CUSTOMER_TABLE * * *
_ FRSAMP ORDER_LINE_TABLE * * 2
_ FRSAMP ORDER_TABLE * * *
_ FRSAMP PART_TABLE * * *
_ FRSAMP SUPPLIER_TABLE * 4 *
_ 'TSOID01.FRSAMP.CONTACTT' * * * Excl Scope
_ 'TSOID01.FRSAMP.CUSTOMER' * * * Excl User
_ 'TSOID01.FRSAMP.ORDERLIN' * * * Excl Scope
_ 'TSOID01.FRSAMP.ORDERTAB' * * * Excl Scope
_ 'TSOID01.FRSAMP.PARTTABL' * * * All
_ 'TSOID01.FRSAMP.SUPPLIER' * * *
******************************* Bottom of data ********************************
To view the Navigation Settings for each relationship: | |
|---|---|
In this field… | Do the following: |
Command | Type the NAV primary command to view the Relationship Navigation Criteria screen. |
Press Enter | File-AID/RDX displays the Relationship Navigation Criteria screen . |
Field Names and Descriptions
For descriptions of the field names, primary and line commands, see Field Names and Descriptions.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*