Result sets
Embedded SQLJ uses iterator objects to manage result sets returned
by SELECT statements. A result-set iterator is a Java™ object from which you can retrieve the
data returned from the database. Iterator objects can be passed as
parameters to methods and manipulated like other Java objects.
Important: Names of iterator classes must be unique within an application.
When you declare an iterator object, you specify a set of Java variables to match the SQL columns that your SELECT statement returns. There are two types of iterators: positional and named.