IBM DB2

Syntax
 : simple-variable
IN (complex-expression)
OUT
INOUT

Description
: Indicates that the variable or expression that follows is a host expression. The
colon must immediately precede the variable or expression.
IN|OUT|INOUT
For a host expression that is used as a parameter in a stored procedure call,
identifies whether the parameter provides data to the stored procedure (IN),
retrieves data from the stored procedure (OUT), or does both (INOUT). The
default is IN.
simple-variable
Specifies a Java unqualified identifier.
complex-expression
Specifies a Java expression that results in a single value.
Usage notes
v A complex expression must be enclosed in parentheses.
v ANSI/ISO rules govern where a host expression can appear in a static SQL
statement.
Related concepts
“Variables in SQLJ applications” on page 110
SQLJ implements-clause
The implements clause derives one or more classes from a Java interface.
Syntax
 implements

,
interface-element

interface-element:
 sqlj.runtime.ForUpdate
sqlj.runtime.Scrollable
user-specified-interface-class

Description
interface-element
Specifies a user-defined Java interface, the SQLJ interface
sqlj.runtime.ForUpdate or the SQLJ interface sqlj.runtime.Scrollable.
You need to implement sqlj.runtime.ForUpdate when you declare an iterator
for a positioned UPDATE or positioned DELETE operation. See ″Perform
282 Application Programming Guide and Reference for Java
™