UDF to select register from database and return in XML format

[Former Member]

Hello,

I need implemented a UDF for select register from database (JDBC) and the result of query return to mapping in XML format,

How I can do it?

Thanks,

Silvia

[rajasekhar_reddy14]

How values are stored in Data base, if values are stored in XML format(BLOB) then perform look from PI mapping and you can returns XML results.

If values are stored in string or integer format then perform a lookup and get the value , write a logic in UDF to format like a xml . this is works.

Could you please tell me why you want output in XML format?any specific reason?