Hi sriram.mk3, is it possible for you to implement the query as a JDBC dataset and then iterate over the rows? The Read Rows from a JDBC Table dataset, returns your SQL query in a dataset which enables you to iterate over the rows one at a time until you have processed the data. The DevTest framework provides all the heavy lifting and exposes the columns selected in your query.
For example:
And, then iterate over the resultset until you process the resultset. At end, you can control branching to complete the process or end the test.
The value in this approach is that you are not implementing custom logic to directly access and loop over the resultset stored in DevTest. Since CA reserves the right to change how processing occurs in DevTest, implementing custom behavior opens the door to potential issues during an upgrade. Utilizing OOTB features as much as possible provides a path for obtaining assistance from our product support team for resolving product related issues, should they arise.