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.
Usage notes
v An iterator declaration clause can appear anywhere in a Java program that a
Java class declaration can appear.
v When a named iterator declaration contains more than one pair of Java data
types and Java IDs, all Java IDs within the list must be unique. Two Java IDs are
not unique if they differ only in case.
Related concepts
“Data retrieval in SQLJ applications” on page 123
Related tasks
“Using a named iterator in an SQLJ application” on page 124
“Using a positioned iterator in an SQLJ application” on page 126
“Using scrollable iterators in an SQLJ application” on page 130
Related reference
“SQLJ clause” on page 281
SQLJ executable-clause
An executable clause contains an SQL statement or an assignment statement. An
assignment statement assigns the result of an SQL operation to a Java variable.
This topic describes the general form of an executable clause.
Syntax
context-clause
statement-clause
assignment-clause
Usage notes
v An executable clause can appear anywhere in a Java program that a Java
statement can appear.
v SQLJ reports negative SQL codes from executable clauses through class
java.sql.SQLException.
If SQLJ raises a run-time exception during the execution of an executable clause,
the value of any host expression of type OUT or INOUT is undefined.
Related concepts
“SQL statement execution in SQLJ applications” on page 112
Related reference
“SQLJ clause” on page 281
“SQLJ assignment-clause” on page 291
“SQLJ context-clause” on page 288
“SQLJ statement-clause” on page 288
Chapter 7. JDBC and SQLJ reference information 287
|
|
To Next Page
Loading...
Need help?
General