Can Pega send DB query using bind masking values?
We are doing a performance tuning in Model Office with client DBA.
Can someone please help with his question?
The binding values I am referring to are contact ID and Work ID. Instead of sending literal values, can they be sent as bind masking values (e.g. ??) and how?
SELECT CreateDateTime AS "CreateDateTime" , WorkID AS "WorkID" , pyLabel AS "pyLabel" , ContactName AS "ContactName" , FullName AS "FullName" , StatusWork AS "StatusWork", pxCreateOpName AS ".pxCreateOpName" , pxInsIndexedKey AS "pxInsIndexedKey", RefundType AS "RefundType", pxObjClass as "pxObjClass"
FROM NCOMPDATA.NCompassMA_Index_IntrSrv
WHERE ContractID IN ('0123456789') AND Type = 'Service' AND StatusWork IN ('Open','Resolved-Completed','Pending-Processing','Pending-Reprocessing','Pending-Follow up','Pending-ResearchSolution') AND timestamp(Current timestamp - 30 DAYS) <= CREATEDATETIME AND pxInsIndexedClass = ? AND WorkID != 'S-12345' order by CreateDateTime desc
JPMorgan Chase & Company
US
Hi,
Could you please let us know where you are writing this SQL query, pega accept the bind variables for auto generated queries.
Pegasystems Inc.
IN
Hi,
bind variable is a placeholder in a SQL statement that must be replaced with a valid value or value address for the statement to execute successfully. By using bind variables, you can write a SQL statement that accepts inputs or parameters at run time.
http://oracle.readthedocs.io/en/latest/plsql/bind/
I think Pega sends Query using Prepared statements and bind variable itself when we use OBJ- method.
Thanks,
Ujjwal