Load Referential Integrity Relation Information

The Load Referential Integrity Relation Information sequential file is used for the layout of a sequential CSV file in text format and is populated during the Data Subsetting phase. The Sample data folder on the installation CD contains the file modref1 which is a sample of this interface.

The following table describes the fields in the Load Referential Integrity Relation Information sequential file:

Field Type Maximum Length Description Mandatory
Parent_Creator CHAR 128 parent Table Creator Yes
Parent_Table CHAR 128 parent table name Yes
Parent_Field CHAR 30 parent column name Yes
Child_Creator CHAR 128 child table creator Yes
Child_Table CHAR 128 child table name Yes
Child_Field CHAR 30 child column name Yes
File_Type CHAR 04 file type No
Relation_Name CHAR 18 Name of relation. Suggested if you have to identify different set of fields belonging to the same file, that describe a different relation. No
Db_name CHAR 128 leave blank No
Important: Every line must end with four semicolons. For example:
NRT40OW;CUSTOMER;COD_CUS;NRT40OW;ACCOUNT;COD_CUS;;;;
NRT40OW;ACCOUNT;OFF_NUM;NRT40OW;CCARD;OFF_NUM;;;;