Data Disguise - Object List

The Data Disguise - Object List screen shown in the following figure is displayed when press END on the ObjectIn-Preview window when you create a new object list, after selecting Option 1, Create and Modify criteria from the Data-Disguise-Menu.

This screen displays the list of the objects, in alphabetical order, that have been filtered into the Object List. From this list you select an object in order to create or modify disguise criteria for the object. Disguise criteria are defined for an object and will be applied whenever that object is extracted and disguise is requested for the extract file.

Data Disguise - Object List

After selecting all desired objects to be included in the object list, press END to proceed to the Data-Disguise-Column-Field-List.

Object Name

Identifies the name of the objects that match the specified object filter.

Disguised Columns/Fields

Displays the names of the columns and fields with disguise criteria defined. This field is a scrollable field so the entire contents of the field may not be displayed in the area allowed. Position the cursor on the field and enter the EXPAND command to view the entire field contents.

Line Commands

The following File-AID for Db2-specific line command is valid:

S (Select)

Selects this object for data disguise and displays the Data-Disguise-Column-Field-List. If the selected object is an MVS file for which File-AID for Db2 does not have any record layout information, File-AID for Db2 displays the MVS XREF/Record Layout Window where you must specify the applicable record layout information.

I (Info)

Displays the Disguised Columns/Fields for each object, as shown in the following figure. Displays the disguised columns/fields with the disguise rule and disguise description for the selected object. The Disguise Rule field is scrollable, use LEFT and RIGHT commands to view the remainder of the description field.

Disguised Columns Information

O (ObjectOut)

Removes this object from the object list.

R (Related objects)

Searches the relationship file and displays any related objects that are not yet included in the object list (see the following figure). Then you can select any of the related objects to be added to the object list.

Related ObjectIn Preview

L (List DB)

Lists all objects that are in the same database as this object and are not already in the Object List (see the following figure). Then you can select any of the objects to be added to the object list.

Database ObjectIn Preview

Primary Commands

The following File-AID for Db2-specific primary commands are valid:

OBJECTIN (OI)

Allows you to add objects to your current object list. This command displays either the ObjectIn - DB2 Object Filter or ObjectIn - MVS Object Filter screen. The ObjectIn Filter screens work the same as the NEW - DB2 Object Filter and NEW - MVS Object Filter with the exception that the relationship file, Db2 SSID and Db2 Location fields are protected.

OBJECTOUT (OO)

Allows you to remove objects from your current object list. This command displays either the ObjectOut - DB2 Object Filter or ObjectOut - MVS Object Filter screen (NEW - MVS Object Filter).

FIND (F)

Searches the 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.

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 format.

ObjectOut - DB2 Object Filter

The ObjectOut - DB2 Object Filter screen shown in the following figure is displayed when you enter the OO command in the Data Disguise - Object List, or you enter the DB2 command in the ObjectOut - MVS Object Filter screen.

Use this screen to specify a Db2 object filter to remove Db2 objects from your current object list.

ObjectOut - DB2 Object Filter

After entering the information for the new Db2 object filter, press ENTER to proceed to the ObjectOut Preview.

DB2 Objects Filter Area

Use the fields in this area to specify the Db2 objects to be removed from your current object list. specifying patterns in the fields, File-AID for Db2 searches the object list to find matches.

SSID

Displays the current Db2 subsystem ID.

Location

Displays the current Db2 location.

Creator

Specify the authorization ID of the owner of the objects that you want to remove from the object list. Enter a pattern in this field if you want to remove objects from more than one creator. Valid pattern characters are %, _, and * (see Wildcard-Characters).

Table Name

Specify a pattern for the object names you want to remove from the object list. Valid pattern characters are %, _, and * (see Wildcard-Characters).

Primary Command

The following File-AID for Db2-specific primary command is valid on this screen:

MVS (M)

Switches to the NEW - MVS Object Filter panel prefilled with the applicable information from your profile. Refer to NEW - MVS Object Filter.

ObjectOut - MVS Object Filter

The following figure is displayed when you enter the OO primary command in the Data Disguise - Object List, or you enter the MVS primary command in the ObjectOut - DB2 Object Filter screen.

Use this screen to specify an MVS object filter to remove MVS objects from your current object list.

ObjectOut - MVS Object Filter

After entering the information for the MVS object filter, press ENTER to proceed to the “ObjectOut Preview”.

MVS Objects Filter Area

Use the fields in this area to specify the MVS objects to be removed from your current object list. specifying patterns in the fields, File-AID for Db2 searches the object list to find matches.

File name

Specify the MVS file name pattern for the objects you want to remove from the object list. Valid pattern character is * (see Wildcard-Characters).

Primary Command

The following File-AID for Db2-specific primary command is valid on this screen:

DB2 (D)

Switches to the ObjectOut - DB2 Object Filter panel prefilled with the applicable information from your profile. Refer to ObjectOut - DB2 Object Filter.

ObjectOut Preview

The following figure is displayed any time after you press enter on either ObjectOut - DB2 Object Filter or the ObjectOut - MVS Object Filter screens. It displays the results of your object filter search and allows you to select all, none, or individual objects to be removed from your current object list.

Use this preview to select only those objects you want to remove.

ObjectOut Preview

After selecting all desired objects to be removed from the object list, press END to return to the Data Disguise - Object List.

Object Name

Identifies the name of the objects that match your specified object filter.

Line Commands

The following File-AID for Db2-specific line command is valid:

S (Select)

Selects and marks this object to be removed from the object list. Blank out the S marker for individual objects you don’t want removed from the object list. Use in conjunction with the ALL primary command to mark your selections.

Primary Commands

The following File-AID for Db2-specific primary commands are valid:

ALL

Selects and marks all objects listed in the preview to be removed from the object list. Blank out the S marker for individual objects you don’t want removed from the object list. Use in conjunction with the S line command to mark your selections.

FIND (F)

Searches the preview 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.

MVS XREF/Record Layout Window

When you select an MVS file with the S line command in the Data Disguise - Object List for which File-AID for Db2 does not have any record layout information, File-AID for Db2 displays the “MVS XREF/Record Layout” window where you must specify the applicable record layout information.

MVS XREF/Record Layout Window

Field Descriptions

MVS File Name

Displays the file name of the selected MVS object.

Specify Record Layout and XREF Information

In the following fields you specify the record layout information to be used for the selected object.

Record layout usage

Indicate whether a single record layout (usage "S"), or an XREF (usage "X") had been used to define the record layout information.

Record layout file

Specify the record layout file for the MVS object. To view a list of layout files, specify a pattern. Valid pattern character is * (see Wildcard-Characters). If you specify a pattern, select a file from the Catalog Utility File List as shown in MVS Catalog Utility File List (for Pattern FAS*.LAY*).

Member name

Specify the member of the record layout file that contains the layout information for the MVS object. Leave blank or use a pattern to narrow the search.

XREF file

Only needed if layout usage is X. Specify the XREF file name for the MVS object from which you want to extract related data. Valid pattern character is * (see Wildcard-Characters). If you specify a pattern, select a file from the Catalog Utility File List as shown in MVS Catalog Utility File List (for Pattern FAS*.LAY*).

Member name

Specify the member of the XREF file that contains the layout information for the MVS object. Leave blank or use a pattern to narrow the search, see also XREF Select Member List Screen.

MVS Catalog Utility File List

When specifying a pattern in the Record layout file or XREF File name fields in the MVS XREF/Record Layout Window, File-AID for Db2 searches the MVS catalog and displays any matches. Select the file name you want to place in the applicable field with the S line command. The message in the top line indicates for which field the list is displayed:

• Select Record Layout
• Select XREF file

MVS Catalog Utility File List (for Pattern FAS*.LAY*)

Field Descriptions

Dataset Name

File names that match the entered file name pattern.

Type

Catalog entry type. Types that may be displayed include: CLUSTER, DATA, INDEX, ALT INDEX, PATH, NON-VSAM, GDG BASE, USER CTLG, ALIAS, and PAGESPACE.

Volume

Volume on which the file is stored. Multi-volume files are identified by the + (plus sign) following the Volume field.

PDS Processing Options

A PDS Processing Options screen, as shown in PDS Processing Options Screen, is displayed when the file name on the NEW-MVS-Object-Filter screen refers to a partitioned dataset (PDS). It is used to specify member selection values to choose members based on a name mask, name range, the userid for last modification, and creation and modification date ranges.

To display a nonselective member list, leave all member selection options blank on the PDS Processing Options screen and press Enter.

PDS Processing Options Screen

Field Descriptions

The following list describes all PDS processing options that File-AID for Db2 can present.

Member name mask

Specify a member name mask to select a subset of members based on the mask criteria. A pattern member name or mask consists of explicit characters or a combination of explicit and pattern characters.

Member name range

Specify a member name range to select a subset of members based on the characters in the member name. The endpoint member names (FROM and TO) can be complete or partial and are included in the member list when found. Pattern characters are not allowed.

If the FROM member field is blank and a TO member is specified, File-AID for Db2 selects the members less than or equal to the TO member padded with high values.

If a FROM member field is specified and the TO member is blank, File-AID for Db2 selects members greater than or equal to the FROM member padded with low values.

Entering the same characters in the FROM and TO fields selects all members beginning with those characters.

Last modified userid

Specify a user identification range to select a subset of members based on the user ID that last updated and saved a member. This information is a PDS statistic that is stored in the directory.

The endpoint userids (FROM and TO) can be complete or partial and are included in the member list when found. Pattern characters are not allowed. As with member name range, the FROM field is padded with low values and the TO field is padded with high values.

Members without PDS statistics, because they were not created (STATS OFF) or the statistics were deleted, are not selected.

Creation date

Specify a creation date range to select a subset of members based on their creation date(s). This is a PDS statistic that is stored in its directory.

The endpoint (FROM and TO) dates can be complete or partial and are included in the member list when found. Leading zeros are required when specifying the year, month, and day.

If the FROM date field is blank and a TO date is specified, File-AID selects all members created on or before the specified TO date.

If a FROM member date is specified and the TO date is blank, File-AID selects all members created on or after the specified FROM date.

Entering the same dates in the FROM and TO fields selects members created only on that date. The two-character year is assumed between 1960 and 2059. Partial creation dates are treated positionally (YY/MM/DD) and are padded with default values.

For example, if you enter blanks the default FROM value becomes 60/01/01 and the TO value becomes 59/12/31. If you enter 85, the defaults are 85/01/01 and 85/12/31. If you enter 85/09, the defaults are 85/09/01 and 85/09/30.

Members without PDS statistics, because they were not created (STATS OFF) or the statistics were deleted, are not selected.

Modification date

Specify a modification date range to select a subset of members based on the last modified date(s). This is a PDS statistic that is stored in its directory. The last modified date is updated with the current date each time a member is updated and saved.

See the description of the Creation date field for more information on specifying a modification range. The specifications are identical.

Members without PDS statistics, because they were not created (STATS OFF) or the statistics were deleted, are not selected.

XREF Select Member List

The XREF Select Member List screen, shown in the following figure, is displayed when a blank or a pattern is specified in the Member field for the XREF file name. The list may be scrolled using LOCATE commands (LOC mem) or scrolling commands (such as UP and DOWN).

Select the desired XREF member with the S line command.

XREF Select Member List Screen