Table of Contents

Search

  1. Preface
  2. Introduction
  3. Servers
  4. Console Client
  5. Search Clients
  6. Table Loader
  7. Update Synchronizer
  8. Globalization
  9. Siebel Connector
  10. Web Services
  11. ASM Workbench
  12. Cluster Merge Rules
  13. Forced Link and Unlink
  14. System Backup and Restore
  15. Batch Utilities

Defining Link and Unlink Rules

Defining Link and Unlink Rules

You need to define the link and unlink rules that need to be added or deleted in a flat file. The order of the fields must be as shown below. Each field must be separated by a delimiter (specified by the user).
  1. Rule Type
  2. Subject Record PK
  3. Relationship
  4. Related Record PK
The field definitions are as follows:
Field
Definition
Rule Type
Use this field to specify the type of the rule. A value of "A" represents that the rule needs to be added to the system and "D" represents that a rule needs to be removed from the system.
Subject Record PK
Use this field to specify the PK of the subject record. The subject record is the record to which something should be linked or unlinked.
Relationship
Use this field to specify the relationship between the subject record and related record. A value of "L" represents a Link rule between the subject record and the related record and a value of "U" represents an Unlink rule between the subject record and the related record.
Related Record PK
Use this field to specify the PK of the record that is either linked or unlinked to the subject record.
Example
For adding a link rule
"A","000000005","L","000000006"
For deleting a link rule
"R","000000005","L","000000006"
For adding an unlink rule
"A","000000005","U","000000001"
For deleting an unlink rule
"R","000000005","U","000000001"
Multiple PK record
When using multiple PKs, the Subject and Related PK fields must be in the same order as defined in the UST-Definition section of the SDF file.
For example
For adding a link rule
"A","PK1",”PK2”,"L","PK1",”PK2”
For deleting a link rule
"D","PK1",”PK2”,"L","PK1",”PK2”
For adding an unlink rule
"A","PK1",”PK2”,"U","PK1",”PK2”
For deleting an unlink rule
"D","PK1",”PK2”,"U","PK1",”PK2”
Link and unlink rules for non-existing records will be ignored. A report is generated showing the ignored link and unlink rules.

0 COMMENTS

We’d like to hear from you!