File-AID/MVS XREF file
During the XREF generation process, File-AID/RDX writes to the record layout cross reference information for the extract file into the specified BMC Compuware File-AID/MVS XREF file.
The XREF file has the following characteristics:
File organization
Partitioned (DSORG=PO)
Record format
Variable-blocked (RECFM=VB)
Logical record length
300
The XREF file includes the record layout cross reference information for all extracted objects.
Sample XREF for Extract File
The following figure shows a sample XREF output. It identifies the record layout cross references for the extracted data records in the extract file.
Sample XREF for Db2 and MVS objects
/*
/* CAUTION: If manually editing this member, STATS must be OFF
/* when saving it. Statistics will overlay information in the
/* directory entry needed by File-AID when loading Selection
/* Criteria and XREFs, rendering the member unusable.
/*
/* COMPUWARE assumes no liability for results of using members
/* that have been edited manually.
/*
DEFINEBLOCKS=XREF,
DESCRIPTION ="FILE-AID/RDX GENERATED XREF",
LAYOUT_DSNAME=TSOID01.LAYOUT.PLI,
LAYOUT_FILLER=4
SELECT SET=1,LAYOUT=FRSAMP_CUSTOMER_TABLE,
LAYOUT_MBRNAME=PLIXREF,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D007
SELECT SET=1,LAYOUT=FRSAMP_CONTACT_TABLE,
LAYOUT_MBRNAME=PLIXREF,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D008
SELECT SET=1,LAYOUT=PROD001_PART_TABLE,
LAYOUT_MBRNAME=PARTTABL,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D001
SELECT SET=1,LAYOUT=PROD001_SUPPLIER_TABLE,
LAYOUT_MBRNAME=SUPPLIER,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D002
SELECT SET=1,LAYOUT=PROD001_CUSTOMER_TABLE,
LAYOUT_MBRNAME=CUSTOMER,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D003
SELECT SET=1,LAYOUT=PROD001_ORDER_TABLE,
LAYOUT_MBRNAME=ORDERTAB,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D004
SEL
ECT SET=1,LAYOUT=PROD001_ORDER_LINE_TABLE,
LAYOUT_MBRNAME=ORDERLIN,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D005
SELECT SET=1,LAYOUT=PROD001_CONTACT_TABLE,
LAYOUT_MBRNAME=CONTACTT,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D006
SELECT SET=1,LAYOUT=OBJECT_DFLT,
LAYOUT_MBRNAME=PLIXREF,
LAYOUT_TYPE=DEFAULT
/* CAUTION: If manually editing this member, STATS must be OFF
/* when saving it. Statistics will overlay information in the
/* directory entry needed by File-AID when loading Selection
/* Criteria and XREFs, rendering the member unusable.
/*
/* COMPUWARE assumes no liability for results of using members
/* that have been edited manually.
/*
DEFINEBLOCKS=XREF,
DESCRIPTION ="FILE-AID/RDX GENERATED XREF",
LAYOUT_DSNAME=TSOID01.LAYOUT.PLI,
LAYOUT_FILLER=4
SELECT SET=1,LAYOUT=FRSAMP_CUSTOMER_TABLE,
LAYOUT_MBRNAME=PLIXREF,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D007
SELECT SET=1,LAYOUT=FRSAMP_CONTACT_TABLE,
LAYOUT_MBRNAME=PLIXREF,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D008
SELECT SET=1,LAYOUT=PROD001_PART_TABLE,
LAYOUT_MBRNAME=PARTTABL,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D001
SELECT SET=1,LAYOUT=PROD001_SUPPLIER_TABLE,
LAYOUT_MBRNAME=SUPPLIER,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D002
SELECT SET=1,LAYOUT=PROD001_CUSTOMER_TABLE,
LAYOUT_MBRNAME=CUSTOMER,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D003
SELECT SET=1,LAYOUT=PROD001_ORDER_TABLE,
LAYOUT_MBRNAME=ORDERTAB,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D004
SEL
ECT SET=1,LAYOUT=PROD001_ORDER_LINE_TABLE,
LAYOUT_MBRNAME=ORDERLIN,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D005
SELECT SET=1,LAYOUT=PROD001_CONTACT_TABLE,
LAYOUT_MBRNAME=CONTACTT,
LAYOUT_TYPE=BASE
IF
POSITION=1,LENGTH=4,OPERATOR=EQ,
TYPE=T,VALUE=D006
SELECT SET=1,LAYOUT=OBJECT_DFLT,
LAYOUT_MBRNAME=PLIXREF,
LAYOUT_TYPE=DEFAULT
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*