This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

P2K_SMGETUDF#

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