Posted: 13 Nov 2017 9:45 EST Last activity: 14 Nov 2017 11:35 EST
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"
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
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.