P 2 K_SMGLX

P2K_SMGLX#

Functionality#

This database function will return the displayed value associated to a lexicon, given the value in the data base

Parameters#

LEXICON_NAME The lexicon name (usually starts with X_ for provided lexicons)
LEXICON_VALUE the value for the lexicon that is stored in the data base (aka saved value or low value)

Returns:#

Varchar2(30)

Errors:#

If an invalid parameter is passed, then NULL is returned
If there is no value or record for that lexicon and value paid, then NULL is returned

Examples:#

P2K_SMGLX('X_GENDER','01') will retrieve the displayed value of the lexicon X_GENDER for a saved value (in the data base) indicated by the field '10'.

In a Derivation Expression on IDIF you could specify the variable as the "Gender (EID)" and then replace it in the reference to this function as P2K_SMGLX('X_GENDER',~)


Notes #

Click to create a new notes page