XREFLOOKUPNOLOCK_AKEY

Description

Similar to the XREFLOOKUPINTERNAL function, but used only 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 without locking the cross reference record.

If using message queues, use XREFLOOKUPLOCK_AKEY to reduce the possibility of inserting duplicate records. If you are not using message queuing, XREFLOOKUPNOLOCK_AKEY may run faster.

Syntax

XREFLOOKUPNOLOCK_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.

Replaces XREFLOOKUP_AKEY 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

About Cross Reference Keys

XREFLOOKUP

XREFLOOKUPINTERNAL

XREFLOOKUPLOCK_BKEY

XREFLOOKUPNOLOCK_BKEY