Relationship Sampling Criteria panel
The Relationship Sampling Criteria screen is displayed when you enter the VIEW STATUS primary command in the Extract-Scope-Object-View-panel or any of the Relationship Criteria screens.
Relationship Sampling Criteria
Command ===> 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
---- ---------------------------------------------- ----- ------ --- ----------
0001 FRSAMP.CUSTOMER_TABLE * * * Inactive
FRSAMP.CONTACT_TABLE CONTCUST
0002 FRSAMP.CUSTOMER_TABLE * * *
FRSAMP.ORDER_TABLE CUSTOMER-ORDER RELATIONS
0003 FRSAMP.ORDER_TABLE * * *
FRSAMP.ORDER_LINE_TABLE ORDLORD
0004 FRSAMP.PART_TABLE * * *
FRSAMP.ORDER_LINE_TABLE ORDLPRT
0005 FRSAMP.PART_TABLE * * * Inactive
FRSAMP.SUPPLIER_TABLE SUPPPART
0006 FRSAMP.SUPPLIER_TABLE * * * Excl Scope
'TSOID01.FRSAMP.SUPPLIER'
0007 'TSOID01.FRSAMP.CUSTOMER' * * * Inactive
'TSOID01.FRSAMP.CONTACTT'
Use this screen to specify which, if any, relationships to exclude from the extract process and how many rows from dependent objects to extract from those relationships not excluded. In addition, you can request information about a specific relationship.
This screen displays a list of referential integrity (RI) and application (AR) relationships defined in the relationship file for the driving object and the sampling criteria setting for each individual relationship.
If there are more relationships on this list than will fit on this screen, you can scroll the list up and down using standard scrolling commands. For more information, see Scrolling.
Fixed Display Area
In addition to the screen title, the Command field, and the scroll amount input field, the top area of the screen contains:
- A message indicating how many relationships were retrieved for display
- A message indicating the driving object for which these relationships were retrieved
- Db2 subsystem ID and remote location ID if the extract includes Db2 objects
Scrollable Display Area
This screen areas displays a list of referential integrity and application relationships containing the following columns:
Seq
The SEQuence column displays the sequence number for the listed relationships for the current extract request. Enter line commands in this column. For information about valid commands for this screen, see Line Commands.
Object Name (Parent)
Displays the name of the object defined as the parent in a relationship in the upper row (the row with the SEQ number).
Object Name (Dependent)
Displays the name of the object defined as the dependent in a relationship in the lower row, under its parent.
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 each individual relationship. Cycle count limits the number of times a relationship is visited during an extract.
Max Rows
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 record. For KEY relationships, this field is not applicable.
Status
Displays one of the following messages in the upper row:
Message | Explanation |
|---|---|
Excl All | This relationship is excluded from the current extract process as one of the related objects is marked to extract all of its records and not chase any of its relationships. This status is the result of the A (All) line command on the Extract-Scope-Object-View-panel screen. |
Excl Miss | This relationship is excluded from the current extract process because at least one of the related objects does not exist. |
Excl Scope | This relationship, with navigation (DPSI) settings of “----”, is excluded as the result of another relationship’s DPSI settings that make it impossible for the extract to navigate to this relationship. Any changes you make to this relationship directly have no affect on the extract. This includes changes to the sampling criteria and the DPSI settings as well. |
Inactive | A relationship with one or more DPSI switches set to “N”. but none to “Y”, is considered inactive, but still within the scope of the extract as its DPSI settings can be changed. Note that in Object View, an object is marked excluded when all of its relationships are marked inactive. |
Excl User | This relationship is excluded from the current extract process. This status is the result of the EXCLUDE primary or line command. |
KEY Undef | For this relationship you still need to define an output key file with Extract Menu Option 6 - Output Key Files or exclude this relationship from the current extract process, before you can continue. |
KEY Def | An output key file has been defined for this KEY relationship. |
KEY Deleted | The output key file definition for this KEY relationship has been deleted. |
Relationship Name
The lower, second Status row for each relationship displays the relationship name (Db2 RI RELNAME or the relationship description for application relationships).
Line Commands
For the description of the available line commands, see Line Commands.
Primary Commands
See Primary Commands for the description of the available primary commands not listed here.
CHANGE (C)
Change allows global changes to be made to the sampling criteria on a column-by-column basis. When the CHANGE command is entered with one of the available parameters CYC=n, MAXROW=n, or DEP=n, all values are changed to the new value n. When entered without parameters, specify the values to change in the CHANGE Command Window - Relationship Sampling Criteria.
CHANGE Command Window
When you enter the CHANGE command without parameters, File-AID/RDX will pop up the CHANGE Command Window - Relationship Sampling Criteria as shown in the following figure.
CHANGE Command Window - Relationship Sampling Criteria
Command ===>
Change ALL occurrences of "from string" value to "to string"
From string ===>
To string ===>
Act on the following fields: Primary command:
Cycle ===> N ( Y = Yes, N = No) Change CYCle=n
MaxRow ===> N Change MAXROW=n
Dep ===> N Change DEP=n
END to process and return
***NOTE: Change will be applied to all qualified objects,
even those that are excluded or hidden.
Enter the Change ‘from string’ and the Change ‘to string’ values and select the sampling criteria types you want to change globally for all relationships.
From string
Enter the current From (old) string you want to change to the To (new) string in the sampling criteria.
To string
Enter the to (new) string you want to replace the from (old) string with in the specified sampling criteria.
Cycle
Enter Y to apply the change to all matching Cycle values. Enter N if the change is not to be applied to the Cycle sampling criteria.
MaxRow
Enter Y to apply the change to all matching MaxRow values. Enter N if the change is not to be applied to the MaxRow sampling criteria.
DEP
Enter Y to apply the change to all matching Dependents-per-parent values. Enter N if the change is not to be applied to the Dependents-per-parent sampling criteria.