How to: |
The CHILD, PARENT, and JUMP commands enable you to display the data in different segments of a data source.
To display instances in a child segment relating to the current instance, enter
CHIld
or press PF5 or PF17. If the segment on the screen when you enter the command has only one child segment, FSCAN shows the child segment. If the segment on the screen has more than one child segment, FSCAN displays a menu of child segments. Select a segment by entering its number. (Note: The menu does not display segments restricted to you as a result of DBA restrictions.)
If you already know the number of the segment on the menu, you can skip the menu by entering
CHIld n
where:
is the number of the segment on the menu.
You can display the child instances of any instance on the screen by typing C in the prefix area next to the instance. You can skip the menu by typing C followed by the number of the segment on the menu.
For example, suppose you are displaying the root segment of the EMPLOYEE database and you want to see the monthly pay of Mary Smith. Monthly pay is contained in the segment SALINFO, a child of the root segment. First, make Mary Smith's instance the current instance. Then, enter the command:
CHILD
The following menu appears:
FSCAN FILE EMPLOYEEFOCUS A1 CHANGES :0 Please enter the number of the child segment you want 1)FUNDTRAN 2)PAYINFO 3)ADDRESS 4)SALINFO => Enter the number of the child you want Enter 0 to stay at parent. |
Enter the number 4. The following screen appears:
FSCAN FILE EMPLOYEEFOCUS A1 CHANGES :0 EMP_ID : 112847612 PAY_DATE GROSS -------- ----- == 820831 1100.00 == 820730 1100.00 == 820630 1100.00 == 820528 1100.00 == 820430 1100.00 == 820331 1100.00 == 820226 1100.00 == 820129 1100.00 --------------------------------INPUT---------------------------------- == ==> |
Note that the header displays the key field value of the parent instance. Since EMP_ID is the key field of the root segment, the header displays Mary Smith's employee ID.
Also, you could have gone directly from the EMPLOYEE root segment to the monthly pay segment by doing one of the following:
To return to the parent segment, enter
Parent
or press PF4 or PF16. The current instance in the parent is the same as before you entered the CHILD command or C prefix area command.
To move to the first child of the next parent instance, enter
JUMP
or press PF12 or PF24 while FSCAN is displaying a child segment.
For example, if you enter JUMP while the PAYINFO segment is being displayed for a particular employee, the PAYINFO segment for the next employee in the EMP_INFO segment is displayed. JUMP may be issued anywhere.
|
Information Builders |