P2K_SMGLX#
Functionality#
This database function will return the displayed value associated to a lexicon, given the value in the data baseParameters#
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 returnedIf there is no value or record for that lexicon and value paid, then NULL is returned
Examples:#
P2K_SMGLX('X_GENDER',GENDER) will retrieve the displayed value of the lexicon X_GENDER for a saved value (in the data base) indicated by the field GENDER.
In a Derivation Expression on IDIF you could specify the variable as the GENDER and then replace it in the reference to this function as P2K_SMGLX('X_GENDER',~)