Description
Similar to the XREFLOOKUPINTERNAL function, but designed for use only with the KEYCROSSREFERENCETWOWAY table in the Scribe Internal Database. Looks up the value in APP_A_KEY and returns the value in APP_B_KEY. XREFLOOKUPLOCK_BKEY creates a lock on the cross reference record while performing the lookup. The lock is released when a value is returned.
Syntax
XREFLOOKUPLOCK_BKEY( LabelValue, AppAKeyValue )
| Parameter | Description |
|---|---|
| LabelValue | The object label in the KEYCROSSREFERENCETWOWAY table to be used for the lookup. |
| AppAKeyValue | The value to be looked up in the APP_A_KEY field. |
Remarks
Note: This function requires special handling when working with bulk operations. See Using Bulk Operations for more information.
This function is used when generating the user variable in the Cross Reference Keys window.
When working with message queues as your source, you can have multiple DTS files using the cross reference tables at the same time; locking the record during the lookup prevents Insight from inserting duplicate records. The lock is released when a value is returned in APP_B_KEY.
See also