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;

 

 

know_more.png

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!

Attachments

Outcomes