Syntax
Java-modifiers
iterator Java-class-name
implements-clause with-clause
( positioned-iterator-column-declarations )
named-iterator-column-declarations
positioned-iterator-column declarations:
,
Java-data-type
named-iterator-column-declarations:
,
Java-data-type Java-ID
Description
Java-modifiers
Any modifiers that are valid for Java class declarations, such as static, public,
private, or protected.
Java-class-name
Any valid Java identifier. During the program preparation process, SQLJ
generates an iterator class whose name is this identifier.
implements-clause
See ″SQLJ implements-clause″ for a description of this clause. For an iterator
declaration clause that declares an iterator for a positioned UPDATE or
positioned DELETE operation, the implements clause must specify interface
sqlj.runtime.ForUpdate. For an iterator declaration clause that declares a
scrollable iterator, the implements clause must specify interface
sqlj.runtime.Scrollable.
with-clause
See ″SQLJ with-clause″ for a description of this clause.
positioned-iterator-column-declarations
Specifies a list of Java data types, which are the data types of the columns in
the positioned iterator. The data types in the list must be separated by
commas. The order of the data types in the positioned iterator declaration is
the same as the order of the columns in the result table. For online checking
during serialized profile customization to succeed, the data types of the
columns in the iterator must be compatible with the data types of the columns
in the result table. See ″Java, JDBC, and SQL data types″ for a list of
compatible data types.
named-iterator-column-declarations
Specifies a list of Java data types and Java identifiers, which are the data types
and names of the columns in the named iterator. Pairs of data types and names
must be separated by commas. The name of a column in the iterator must
match, except for case, the name of a column in the result table. For online
286 Application Programming Guide and Reference for Java
™