Question
6
Replies
688
Views
AIG
Posted: October 19, 2016
Last activity: October 28, 2016
Closed
Calling Pega UDFs from database
Hi,
We are using DB2 database on z/OS. To extract data from BLOBs, we'd like to run Pega UDFs directly on Pega DB without using PRPC. Can we invoke UDFs and retrieve results on DB server? If so, how can we do this and save results to a staging DB or to a staging location in XML format?
We are considering this approach as using UDFs from PRPC has performance impacts.
Thanks!
The current UDFs shipped with the product only return scalar values. They don't return the entire BLOB as JSON / XML to be saved into a file.
They can be used directly from the database. Please refer to the query generated by the report definition rule when unoptimized properties are used.
If you really want to extract data out of the BLOB into a relational structure, you could consider using declare index or BIX.