Posted: 19 Oct 2016 17:01 EDT Last activity: 28 Oct 2016 0:59 EDT
Calling Pega UDFs from database
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.
What version of Pega are you on? UDFs were introduced in 6.2sp2 and are used for any unoptimized properties. If you are running reports with unoptimized properties and do not have UDFs installed then I expect that you are on an earlier version of Pega.
The easiest way figure out if report definition rules executed with unexposed properties are using UDFs or not, is to look at the SQL generated in the results page in the clipboard. If the SQL contains references to pr_read_from_stream function being called, then UDFs are being used. You can also check for the existence of this function in the database to verify if UDFs are installed or not.