P2K_SMGETUDF#
Functionality#
This database function will return the value associated to a specified user defined field (UDF) name, for a record in the specified table.Parameters#
| TABLE_NAME | The complete table name that the UDF is attached to. Tables should be entered in UPPER case. |
| UDF_NAME | The internal name for the User Defined Field (defined on IMUF). UDF name shoould be enetered in UPPER case. |
| REFERENCE_ID | The ID for the record from the table (in parameter 1) that has the UDF attached |
Returns:#
Varchar2(2000)Errors:#
If an invalid parameter is passed, then NULL is returnedIf there is no value or record for that UDF/Reference ID, then NULL is returned
Examples:#
P2K_SMGETUDF('P2K_HR_PERSONALS','EPS01',eps_id) will retrieve the value of the UDF EPS01 associated to the record in P2K_HR_PERSONALS where the ID = the EPS_ID passed
In a derivation expression on IDIF you could specify the variable as the EPS_ID and then replace it in the reference to this function as P2K_SMGETUDF('P2K_HR_PERSONALS','EPS01',~)
