CA 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
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!