@BIND_KEYSET(...)

All functions > CORE > @BIND_KEYSET(...)

Binds entity keys from a keyset, keyset group, or mapped source.

Syntax

@BIND_KEYSET(feature [, ROW(name := expression, ...)])

Notes

• A KEYSET reference pins that population
• A KEYSET_GROUP selects by active-source alignment and group order
• A named ROW supplies compile-time values for :parameters
• An EXTERNAL_COLUMNS() or INLINE_COLUMNS() source may directly drive matching entity keys, whether or not a field is extracted

Related Functions

• KEYSET()

• KEYSET_GROUP()

Examples

Keyset parameter from a constant

CONST NUM := 10
DEFINE
    key_id := INPUT(BIGINT),
    k := KEYSET(ENTITY(), 'SELECT CAST(:num AS BIGINT) AS key_id')
RETURN
    key_id
FOR
    key_id := @BIND_KEYSET(k, ROW(num AS num))
;