SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-6
Host Expression
FOR UPDATE
specifies that the iterator object to which the query expression is assigned is
updatable. For more information, see Positioned UPDATE and DELETE
Statements on page 3-55.
Iterator Conversion Clause
An iterator conversion clause converts a JDBC result set to an SQLJ iterator.
host-expression
specifies a Java host variable or expression that contains a JDBC result set. For
the syntax of host-expression, see Host Expression on page A-6. For more
information, see Creating an Iterator From a JDBC Result Set on page 3-56.
Host Expression
A host expression is a Java variable or expression that is referenced in an SQLJ
executable clause.
:
indicates that the variable or expression that follows is a host expression.
parameter-mode
is IN, OUT, or INOUT. This parameter is optional because the mode can be
inferred from the context.
IN
specifies a host variable or expression that passes data to an SQLJ clause. It
is the default mode if the host expression is not part of an INTO list or the left-
hand part of an assignment expression. See Input Host Variables and
Expressions (IN or INOUT) on page 3-27.
iterator-conversion-clause is:
CAST
host-expression
:[
parameter-mode] expression
parameter-mode is:
IN | OUT | INOUT
expression is:
simple-variable
| (
complex-expression)