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','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',~)
