Description
Similar to the XREFLOOKUP_AKEY function, but needed when using Scribe message queues with the KEYCROSSREFERENCETWOWAY table in the Scribe Internal Database. Looks up the value in APP_B_KEY and returns the value in APP_A_KEY. XREFLOOKUPLOCK_AKEY creates a lock on the cross reference record while performing the lookup. The lock is released when a value is returned.
Syntax
XREFLOOKUPLOCK_AKEY ( LabelValue, AppBKeyValue )
| Parameter | Description |
|---|---|
| LabelValue | The object label in the KEYCROSSREFERENCETWOWAY table to be used for the lookup. |
| AppBKeyValue | The value to be looked up in the APP_B_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_A_KEY.
See also