EasyManua.ls Logo

IBM DB2 - Page 302

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
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

Table of Contents