Sample training tables and files - Documentation for BMC Compuware File-AID/RDX 21.01

The sample Db2 tables and MVS files are created when executing sample JCL (located in the sample library, hlq.SXVJSAMP) to create a complete master set of MVS (XVJTRNM) training files that can be used for all File-AID products. Compuware also provides a dialog to create Db2 sample objects for BMC Compuware File-AID for Db2 and File-AID/RDX. It’s started by executing REXX member XVJTRNDB in the hlq.SXVJSAMP. The Sample Db2 Data Create dialog also sets a Creator ID. For this user guide it was set as FRSAMP.

Important

If you don’t have access to the sample Db2 tables and MVS files you can use the File-AID/RDX Load Option (see Load) to load the data from the sample extract files created with the XFRCOPY CLIST (see also Executing the XFRCOPY CLIST).

The diagram in Sample Tables and Relationships represents the sample Db2 tables provided with File-AID/RDX. The sample extract file FRSAMP.EXTRACT contains data extracted from these tables, based on the shown relationships.

The following explanations describe the sample tables in further detail.

ORDER_TABLE

The Order table drives the extract in the sample scenarios in this training guide. (For an explanation of the extract driving table, see Selecting an Object to Drive the Extract Process.)

The Order table’s primary key column is ORDER_NUMBER.

The Order table is an RI parent of ORDER_LINE_TABLE through a foreign key on column ORD_NUM.

The Order table is an application-related (AR) dependent table of the Customer table through the column CUST_NUM.

CUSTOMER_TABLE

The Customer table’s primary key column is CUSTOMER_NUMBER.

The Customer table is an application-related (AR) parent table of the Order table through the column CUST_NUM.

The Customer table is also an RI parent of the Contact table through a foreign key on column CUSTOMER_NUMBER.

CONTACT_TABLE

The Contact table’s primary key columns are CUSTOMER_NUMBER and CONTACT_ID.

The Contact table is an RI dependent of the Customer table through a foreign key on the column CUSTOMER_NUMBER.

ORDER_LINE_TABLE

The Order Line table’s primary key consists of the columns ORD_NUM and ORDER_LINE_NUMBER.

The Order Line table is an RI dependent of the:

1. Part table through a foreign key on the column PART_NUM.
2. Order table through a foreign key on the column ORD_NUM.

PART_TABLE

The Part table’s primary key column is PART_NUMBER.

The Part table is an RI parent of:

• Order Line table through a foreign key on column PART_NUM.
• Supplier table through a foreign key on column PART_NUMBER.

SUPPLIER_TABLE

The Supplier table’s primary key columns are PART_NUMBER and SUPPLIER_CODE

The Supplier table is an RI dependent of the Part table through a foreign key on the column PART_NUMBER.

Sample Tables and Relationships

In the above figure, ORDER_TABLE is the driving object. The arrows point from the parent table to its dependent table. The Creator authorization ID for all the tables is FRSAMP.

Sample MVS Files

The diagram in Sample Files and Relationships represents the sample MVS files provided with File-AID/RDX. The sample extract file FRSAMP.EXTRACTM contains data extracted from these files, based on the shown application relationships, with ORDERTAB as the driving object.

The following explanations describe the sample files in further detail.

LAYOUTS

Each member in the LAYOUTS file contains the record layout information for the sample data file of the same name, for example, member ORDERTAB has the record layout information for the sample data file ORDERTAB.

ORDERTAB

The ORDERTAB file drives the extract in the provided FRSAMP.EXTRACTM sample extract file. (See Selecting an Object to Drive the Extract Process for an explanation of the extract driving object.)

The ORDERTAB file is an application-related (AR) parent of ORDERLIN through field ORDER-NUM.

The ORDERTAB file is an AR dependent of the CUSTOMER file through field CUSTOMER-NUMBER.

CUSTOMER

The CUSTOMER file is an AR parent of the ORDERTAB file through field CUST-NUM.

The CUSTOMER file is also an AR parent of the CONTACTT file through field CUSTOMER-NUMBER.

CONTACTT

The CONTACTT file is an AR dependent of the CUSTOMER file through field CUSTOMER-NUMBER.

ORDERLIN

The ORDERLIN file is an AR dependent of the:

1. PARTTABL file through field PART-NUMBER.
2. ORDERTAB file through field ORDER-NUMBER.

PARTTABL

The Part table is an AR parent of:

• ORDERLIN file through field PART-NUM.
• SUPPLIER file through field PART-NUMBER.

SUPPLIER

The SUPPLIER file is an AR dependent of PARTTABL through field PART-NUMBER.

Sample Files and Relationships

In the above figure, ORDERTAB is the driving object. The arrows point from the related field in the parent file to the field in its dependent file.

Sample Translate Tables For Use With Data Privacy

A table dataset contains the translate, or lookup, table information for the BMC Compuware File-AID/Data Solutions Data Translator function or the table data used with the TA (Table) Relational Operator (RO) for the Data Generation and Data Validation functions.

The sample translate table PDS (hilevel.TRANSLAT) is created during installation (tasks 16) by the person who installs File-AID/RDX.

The Translate Tables lists the sample translate table members for use with the File-AID/RDX Data Disguise function when defining disguise criteria with BMC Compuware File-AID/Data Solutions.

Important

These sample translate tables are also delivered with BMC Compuware File-AID/EX. BMC Compuware File-AID/Data Solutions includes additional sample translate tables.

Translate Tables

• 1: The SSANDCC translate table is specific for File-AID/RDX and is part of the sample training files.