SQL/MX Programming Manual for Java

SQLJ Syntax
HP NonStop SQL/MX Programming Manual for Java—523726-003
A-3
Iterator Declaration Clause
operation. For more information, see Positioned UPDATE and DELETE Statements
on page 3-55 and sqlj.runtime.ForUpdate Interface on page B-5.
with-clause
determines the properties of the cursor, which underlies the iterator.
sensitivity
has no semantics in the current version of SQL/MX. If you specify the
sensitivity, you must assign a with-value of ASENSITIVE, SENSITIVE, or
INSENSITIVE. ASENSITIVE is the default sensitivity in SQL/MX, which
means that a concurrent DML operation in the same transaction as an iterator
might or might not affect the iterator results.
returnability
has no semantics in the current version of SQL/MX.
holdability
determines if the cursor is a holdable cursor. Holdable cursors are kept open
across transaction boundaries; that is, they are not automatically closed when
the transaction commits. The value of this keyword can be true (holdable) or
false (not holdable). If you do not specify holdability, the default is
false (not holdable).
Holdable cursors can be used only with publish/subscribe streams and queuing
statements. For more information, see the SQL/MX Queuing and
Publish/Subscribe Services manual. For examples, see Appendix C, Sample
Programs.
updateColumns
specifies a list of columns that may be updated by a positioned UPDATE or
DELETE statement. The value of this keyword must be a
String literal that
contains a comma-separated list of column names, as this example shows:
updateColumns="col1,col2,col3"
Use updateColumns only for an iterator that implements the
sqlj.runtime.ForUpdate interface. For more information, see Positioned
UPDATE and DELETE Statements on page 3-55.
positioned-iterator
specifies a list of Java data types, where the data types are separated by commas
and the list is enclosed in parentheses:
(Java-data-type [,Java-data-type]...)
specifies the data types of the columns in the iterator. The number of Java
types in the iterator declaration must be equal to the number of columns in the