Question

3
Replies
178
Views
Will Cho Member since 2008 100 posts
PEGA
Posted: November 13, 2017
Last activity: November 14, 2017
Closed

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

System Administration Data Integration
Moderation Team has archived post
Share this page LinkedIn