If big data sets have to be read from a database, it is recommended not to read all records at once. Instead do the following steps:
In this case, the SQL output cannot be checked against the type since the output record is not known yet in the getHandle operation but only at fetchNext. |
The example below shows an activity executing these steps.
The iteration over the SQL handle using fetchNext has to be implemented by the developer in an activity diagram. For more information refer to Implementing a Loop.