P2K_SMGLXMN#
Functionality#
This database function will return the MEANING associated to a lexicon, given the value in the data base. The P2K_SMGLX function will return the displayed valueParameters#
| 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(50)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_SMGLXMN('X_GENDER',GENDER) will retrieve the meaning field, in IMLN 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_SMGLXMN('X_GENDER',~)
