Posted: 9 May 2016 10:49 EDT Last activity: 12 May 2016 17:14 EDT
Pega 718 UDF Installation Manual
Please share the complete steps to manually install UDF for pega 718 on DB2 and Oracle.I have the UDF script generated for both DB2 and Oracle and prreadstream.jar file available in distribution media.I went through the below article but which does not says how to install java classes on DB2 and oracle before excuting the DDL which anyway fails with out that.Looking for exact steps/ instruction for both DB2 and Oracle.Thanks
I tried this approach and was successful.That article is for single schema i think.How do i specify split schema? I added one more property dev.oracledate.rulesSchema=ruleschema and then ran it twice by changing dev.oracledate.rulesSchema=dataschema.Since i am using a different ID to generate the UDF.I noticed it generated the objects on the ID(Schema) that i used to generate the UDF.
I didn't try the attached steps but i do see java objects are created and all are valid after the pega 718 installation on oracle 12c but the query from the attached document not returning any results.How can i confirm all UDF's are generated correctly on oracle?
Step 8: Execute the below SQL for testing:
SELECT PRPCDATA.pr_read_from_stream('pzInsKey', pzInsKey, pzPVStream) as "StringValue", PRPCDATA.pr_read_int_from_stream('pzRuleSetVersionMajor', pzInsKey, pzPVStream) as "IntegerValue", PRPCDATA.pr_read_decimal_from_stream('pzRuleSetVersionMinor', pzInsKey, pzPVStream) as "DecimalValue" from prpcrules.pr4_rule where pxInsID like 'CANNOT%';