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 without locking the cross reference record.
If using message queues, use XREFLOOKUPLOCK_BKEY to reduce the possibility of inserting duplicate records. If you are not using message queuing, XREFLOOKUPNOLOCK_BKEY may run faster.
Syntax
XREFLOOKUP_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.
Replaces XREFLOOKUP_BKEY in DTS files created in Insight 7 or later.
Use this function to generate the user variable in the Cross Reference Keys window.
See also