Bookshelf Home | Contents | Index | Search | PDF

Siebel Enterprise Integration Manager Administration Guide > Common EIM Usage Examples > Other Examples >

Foreign Key Column Values: NO MATCH ROW ID versus NULL versus a Valid ROW_ID

---

There are three possible values that EIM can define for primary columns (foreign key columns) when it processes a batch:

• NO MATCH ROW ID
• NULL
• A valid ROW_ID

NO MATCH ROW ID. EIM sets the foreign key columns to NO MATCH ROW ID if the primary value cannot be found when EIM processes Step 10. EIM does this because the primary key is missing in the linked table.

NULL. If the foreign key columns allow a NULL value in the parent table, EIM carries the NULL value.

A valid ROW_ID. If a valid ROW_ID is not defined, EIM uses the value in the primary column to determine the ROW_ID.

Bookshelf Home | Contents | Index | Search | PDF