Changing sampling criteria for a relationship
When you enter the SAMPLE command on the Relationship Navigation Criteria panel, File-AID/RDX displays Relationship Sampling Criteria screen as shown in the following figure. The Sampling Criteria Settings are prefilled as specified in your current profile or with your previously saved individual settings. Verify that the values match.
Relationship Sampling Criteria
Command ===> GRAPHIC Scroll ===> CSR
Primary Commands: EXclude/Unex, Change, Find, Hide, FILter, CHEck, SIze, SOrt
VIew, STATus, SAMple, NAVigation, VALidate, GRaphic, REPort
Line Commands: X = Exclude U = Unexclude I = Info
Driving Object: FRSAMP.ORDER_TABLE
SSID: DSN Location: DSNLOCAT Sampling Criteria
Seq Object Name Cycle MaxRow Dep Status
---- ---------------------------------------------- ----- ------ --- ----------
0007 'TSOID01.FRSAMP.CUSTOMER' * * 2
'TSOID01.FRSAMP.CONTACTT' MVS CUST to CONTACTT
0008 'TSOID01.FRSAMP.CUSTOMER' * * * Excl User
'TSOID01.FRSAMP.ORDERTAB' MVS CUST to ORDERTAB
0009 'TSOID01.FRSAMP.CUSTOMER' * 7 *
FRSAMP.CUSTOMER_TABLE MVS CUST to DB2
0010 'TSOID01.FRSAMP.ORDERTAB' * * * Excl Scope
'TSOID01.FRSAMP.ORDERLIN' MVS ORDER to ORDERLIN
0011 'TSOID01.FRSAMP.PARTTABL' * * * Excl All
'TSOID01.FRSAMP.ORDERLIN' MVS PARTTABL to ORDERLIN
0012 'TSOID01.FRSAMP.PARTTABL' * * * Excl All
'TSOID01.FRSAMP.SUPPLIER' MVS PARTTABL to SUPPLIER
******************************* Bottom of data ********************************
To change individual Sampling Criteria for the extract: | |
|---|---|
In this field… | Do the following: |
Sampling Criteria: | Type a 2 in the Dep column next to the following relationship: 0007 'TSOID01.FRSAMP.CUSTOMER' ===> 'TSOID01.FRSAMP.CONTACTT' |
Sampling Criteria: | Type a 7 in the MaxRow column next to the following relationship: 0009 'TSOID01.FRSAMP.CUSTOMER' ===> CUSTOMER_TABLE |
Command | Type the GRAPHIC primary command to view the graphic representation of the relationships to be extracted. |
Press Enter | File-AID/RDX displays the Graphical Relationship Display screen. |
Field Names and Descriptions
Only the Sampling Criteria fields are new for this screen:
FIELD | DESCRIPTION | |
|---|---|---|
Sampling Criteria | Displays the status of the three sampling criteria settings for each relationship. Initially, the sampling criteria are set globally as specified in your current extract profile. You can change each individual setting simply by typing over a new value or use the CHANGE primary command to globally change the sampling criteria fields. | |
Cycle | Specify the maximum number of cycles for all relationships leading from the object. Cycle count limits the number of times a relationship is visited during an extract. | |
MaxRow | Specify the maximum number of rows to extract via downward navigation (direct, indirect and sibling) of this relationship. The Max Rows profile value applies to each relationship and each object. The relationship Max Rows value is processed first; if the count does not exceed the limit, the record is passed on to check against the object Max Rows value. | |
Dep | (Dependents-per-parent) Enter the maximum number of dependent records to be extracted for each parent record extracted. An asterisk (*) indicates that File-AID/RDX will extract all dependent records. A value of 2, for example, specifies to select no more than 2 dependent ORDER records for each extracted parent CUSTOMER records. This value is used only when extract processing proceeds from a parent to a dependent object. For KEY relationships, this field is not applicable. | |
For descriptions of the remaining field names, primary and line commands, see Field Names and Descriptions.