Extract Scope - Object View panel

The following panel is displayed when you specify O in the Extract Scope Detail View field of the Extract Scope Screen or the VIEW primary command from any of the Relationship Criteria screens.

Use this screen to specify which, if any, objects to exclude from the extract process and the maximum number of rows/records that you want extracted from each object. In addition, you can request to view the relationships for a specific object.

This screen displays a list of all the objects in alphabetical order that are part of the extract request, including all objects related to the driving object based on the relationships defined in the relationship file as well as all unrelated objects.

Initially, all objects are displayed. Use the HIDE command to display only select object types.

If there are more objects on this list than will fit on this screen, you can scroll the list up and down using standard scrolling commands. For more information about scrolling, 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 the following information:

• The driving object for which these related objects were retrieved
• The Db2 subsystem and remote location ID where all related Db2 objects reside
• A message indicating the hide/filter status of the display

Scrollable Display Area

This screen areas displays a list of the objects related to the driving object containing the following columns:

CMD

Enter line commands in this column. For information about valid commands for this screen, see Line Commands.

Object Name

Displays the name of the related or unrelated object included in the extract request. For Db2 objects, the creator.tablename is displayed here.

Sampling Criteria

Displays the status of the three sampling criteria for each object. 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

The cycle count can be set for each individual object in the extract.

When entered for an object, it limits the number of times an object can be visited during the extract regardless of the number of relationships.

Max Rows

Specify the maximum number of rows to extract via downward navigation (direct, indirect and sibling) of this object. The Max Rows profile value applies to each relationship and each object. The relationship Max Rows values is processed first; if the count does not exceed the limit, the record is passed on to check against the object Max Rows value.

NTH

(n^th record) Specify how many of the eligible records to be extracted should be skipped and not be extract (a value of 3 would extract records 1 and 4).

L

Lock Table; indicates whether or not the Db2 object (table) will be locked during extract. Use the L line command to change the lock status for an individual table.

Status

Displays one of the following messages:

Line Commands

The following File-AID/RDX-specific line commands are valid on this screen:

A (All)

Extract all data from this object regardless of the relationships from and to this object and do not chase any relationships associated with this object. The A line command acts as a toggle switch: enter it once to set the status, enter it again to remove it.

L (Lock Table)

Indicate whether or not a Db2 table will be locked during extract. See also primary command FUNCTION LOCK that controls whether the L column displays and the L line command is valid. The FUNCTION LOCK command is not available if File-AID/RDX was configured at installation to prevent locking tables during extract. In this case, the L column will not be displayed. The L line command acts as a toggle switch, enter it once and it will set the status to Locked. Enter L a second time, and the Locked status is removed.

P (Passthru)

Don’t extract any data from this object, but process all relationships as if records based on the relationship would have been extracted. The P line command acts as a toggle switch: enter it once to set the status, enter it again to remove it.

R (Relationship View)

Mark this object to be included in the Relationship View when the VIEW primary command is entered.

U (Unexclude)

Selects a previously excluded object (using EXCLUDE primary or line command) to be included in the extract. Remember, you cannot unexclude an excluded object when its link to the driving object is through another, still excluded relationship. See also X (Exclude).

X (Exclude)

Excludes an object from the extract.

When you exclude an object, other relationships or objects might also be excluded as a result. This occurs when you exclude a relationship and either of the objects in the excluded relationship is a parent or dependent in another relationship that cannot be linked back to the driving object in any other way. For example, assume three relationships exist as shown below and ORDER_TABLE is the driving object.

When the PART_TABLE object is excluded, the SUPPLIER_TABLE object will also be excluded as well as the ORDER_LINE_TABLE to PART_TABLE relationship.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

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 NTH=n, all values for the specified parameter are changed to the new value n. When entered without parameters, specify the values to change in the CHANGE Command Window - Object View Sampling Criteria.

CHANGE Command Window

When you enter the CHANGE command without parameters, File-AID/RDX will display the following panel.

CHANGE Command Window - Object View Sampling Criteria

Enter the Change ‘From string’ and the Change ‘To string’ values and select the sampling criteria types you want to change globally for all objects. Then press END to execute the CHANGE command.

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.

Nth

Enter Y to apply the change to all matching Nth values. Enter N if the change is not to be applied to the Nth sampling criteria.

Lock

Enter Y to apply the change to all matching Lock values. Enter N if the change is not to be applied to the Lock Db2 Table column.

CHECK (CHE)

Use the CHECK command to verify the extract paths after you made navigation changes. When the path integrity validation processing is complete, the results are displayed in the Check Extract Warning screen where you can resolve or ignore the findings. File-AID/RDX executes the CHECK command whenever it returns from the Extract Scope Detail View panels.

EXCLUDE (EX or X)

The EXCLUDE command allows to exclude all objects or all objects of a specified object type to be excluded from the extract. EXCLUDE without parameter displays the Exclude Command Window.

Use this command in conjunction with the U (Unexclude) line command or UNEXCLUDE primary command when you have a long list of relationships displayed and you want to include only a few relationships in the extract.

Enter the EXCLUDE ALL command to exclude all objects in the list displayed on the xref_fig_133_Extract_Scope screen from the extract.

The other parameters Db2 and MVS limit the EXCLUDE command to one of the two object types.

EXCLUDE Command Window

When you enter the EXCLUDE command without parameters, File-AID/RDX displays the Exclude Command Window as shown in the following figure. Select the object types you want to exclude from the extract, and optionally, hide from the display.

Exclude Command Window

Select the object types to exclude, then press END to exit the window.

DB2 objects

Enter Y to exclude all Db2 objects/relationships. Enter E to exclude and hide all Db2 objects/relationships. Enter N if you don’t want to exclude all Db2 objects/relationships from the extract. N does not unexclude excluded objects, use the UNEXCLUDE primary or line command.

MVS objects

Enter Y to exclude all MVS objects/relationships. Enter E to exclude and hide all MVS objects/relationships. Enter N if you don’t want to exclude all MVS objects/relationships from the extract. N does not unexclude excluded objects, use the UNEXCLUDE primary or line command.

FIND (F)

Searches the object list for the specified string and scrolls the list to display the first matching entry at the top of the displayed entries. Use RFind to repeat the search.

FUNCTION LOCK

Enables the “Lock Table during Extract” function for all Db2 objects. The xref_fig_133_Extract_Scope panel will display and enable the L line command and display the L status column. See also L (Lock Table). FUNCTION LOCK is a toggle switch so enter FUNCTION LOCK again to return to the original format.

HIDE (H)

The HIDE command allows less data to be displayed. Included or excluded objects can be hidden from the display so that the remaining content is more meaningful. Use the RESET command to return all hidden objects to the display.

HIDE Command Window

When you enter the HIDE command, File-AID/RDX will pop up the Hide Command Window as shown in the following figure. Select the object status types you want to hide from the display.

Hide Command Window

Select the object status types to hide or redisplay, then press END to exit the window.

Included

Enter Y to hide all objects/relationships that are included in the extract. Enter N to display all objects/relationships that are included in the extract.

Excluded

Enter Y to hide all objects/relationships that are excluded from the extract. Enter N to display all objects/relationships that are excluded from the extract.

NAVIGATION (NAV)

The NAVIGATION command takes you directly to the Relationship Navigation Criteria screen.

REPORT (REP)

Prints the logical contents of the display. This report includes all of the displayable lines formatted like the current view.

RESET (RES)

Use the RESET command to return all hidden objects to the display.

SAMPLE (SAM)

The SAMPLE command takes you directly to the Relationship Sampling Criteria screen.

SIZE (SI)

Increases the scrollable area to display more entries at a time by hiding some of the screen header lines. SIze is a toggle switch so enter SIze again to return to the original display format.

STATUS (STAT)

The STATUS command takes you directly to the Relationship Criteria screen.

UNEXCLUDE (U)

The UNEXCLUDE command allows you to unexclude all objects or all objects of a specified object type to be included in the extract. UNEXCLUDE without parameter displays the Unexclude Command Window.

Use this command in conjunction with the X (eXclude) line command or EXCLUDE primary command when you have a long list of objects displayed and you want to reverse a previous EXCLUDE command to include objects in the extract again.

Enter the UNEXCLUDE ALL command to undo a previous EXCLUDE command for all objects in the list displayed on the xref_fig_133_Extract_Scope screen from the extract.

The optional parameters Db2 and MVS limit the UNEXCLUDE command to one of the two object types.

UNEXCLUDE Command Window

When you enter the UNEXCLUDE command without parameters, File-AID/RDX displays the Unexclude Command Window as shown in the following figure. Select the object types you want to include in the extract again (reverse a previous EXCLUDE line or primary command).

Unexclude Command Window

Select the object types to unexclude, then press END to exit the window.

DB2 objects

Enter Y to unexclude all Db2 objects. Enter N if you don’t want to unexclude all Db2 objects. N does not exclude included objects, use the EXCLUDE primary or line command.

MVS objects

Enter Y to unexclude all MVS objects. Enter N if you don’t want to unexclude all MVS objects from the extract. N does not exclude included objects, use the EXCLUDE primary or line command.

VIEW (VI)

The VIEW command allows you to easily switch between the object and relationship views. The optional parameters SAMPLE, STATUS (default) and NAVIGATION can be used to go directly to the corresponding format of the relationship view. You can also enter these parameters as stand-alone primary commands although they are not included on the primary command line for the object view but will be processed if entered.