positioned UPDATE and DELETE operations in an SQLJ application″ for
information on performing a positioned UPDATE or positioned DELETE
operation in SQLJ.
You need to implement sqlj.runtime.Scrollable when you declare a
scrollable iterator. See ″Use scrollable iterators in an SQLJ application″ for
information on scrollable iterators.
Related tasks
“Performing positioned UPDATE and DELETE operations in an SQLJ
application” on page 114
“Using scrollable iterators in an SQLJ application” on page 130
Related reference
“SQLJ connection-declaration-clause” on page 285
SQLJ with-clause
The with clause specifies a set of one or more attributes for an iterator or a
connection context.
Syntax
with
,
( with-element )
with-element:
holdability=true
holdability=false
sensitivity=ASENSITIVE
sensitivity=INSENSITIVE
sensitivity=SENSITIVE
dynamic=false
, dynamic=true
,
updateColumns= ″ column-name ″
Java-ID=Java-constant-expression
dataSource= ″ logical-datasource-name ″
Description
holdability
For an iterator, specifies whether an iterator keeps its position in a table after a
COMMIT is executed. The value for holdability must be true or false.
sensitivity
For an iterator, specifies whether changes that are made to the underlying table
can be visible to the iterator after it is opened. The value must be
INSENSITIVE, SENSITIVE, or ASENSITIVE. The default is ASENSITIVE.
For connections to IBM Informix Dynamic Server (IDS), only INSENSITIVE is
supported.
dynamic
For an iterator that is defined with sensitivity=SENSITIVE, specifies whether
the following cases are true:
Chapter 7. JDBC and SQLJ reference information 283
To Next Page
Loading...
Need help?
General