CA PAM::. How to use Query_Database and Loop - Process Example

Document created by TMACUL Champion on Feb 10, 2017
Version 1Show Document
  • View in full screen mode

HowItWorks.jpgCA PAM - How to use Query_Database and loop



01. Execute Query

CA PAM::. How to use Query_Database operator - Process Example 


02. Row Count


Post-execution code

Process.numTotalRows = Process[OpName].QueryResults.ResultSets[0].Rows[0].TotalRow;
Process.numRowsPerLoop = 100;
Process.numLoopsRequired = Math.ceil(Process.numTotalRows / Process.numRowsPerLoop);
Process.currentLoop = 0;


03. Loop Property


  • Repeat Count
    • Process.numLoopsRequired


04. For next step


On this example is Post-Execution Code on FetchDatabase operator

Process.currentLoop += 1;




CA PAM::. How to read a XML file - applyXPath Function 

Summary CA Process Automation 

Summary CA Service Management Community 

Service Desk Manager 15 days Implementation 

CABI:: Summary - BOXI for CA SDM 

Summary CA SDM Scoreboard 




Was useful, please leave your feedback!

1 person found this helpful