v When the application executes positioned UPDATE and DELETE statements
with the iterator, those changes are visible to the iterator.
v When the application executes INSERT, UPDATE, and DELETE statements
within the application but outside the iterator, those changes are visible to
the iterator.
The value for dynamic must be true or false. The default is false.
DB2 Database for Linux, UNIX, and Windows servers do not support dynamic
scrollable cursors. Specify true only if your application accesses data on DB2
for z/OS servers, at Version 9 or later.
For connections to IDS, only false is supported. IDS does not support
dynamic cursors.
updateColumns
For an iterator, specifies the columns that are to be modified when the iterator
is used for a positioned UPDATE statement. The value for updateColumns
must be a literal string that contains the column names, separated by commas.
column-name
For an iterator, specifies a column of the result table that is to be updated
using the iterator.
Java-ID
For an iterator or connection context, specifies a Java variable that identifies a
user-defined attribute of the iterator or connection context. The value of
Java-constant-expression is also user-defined.
dataSource
For a connection context, specifies the logical name of a separately-created
DataSource object that represents the data source to which the application will
connect. This option is available only for the IBM Data Server Driver for JDBC
and SQLJ.
Usage notes
v The value on the left side of a with element must be unique within its with
clause.
v If you specify updateColumns in a with element of an iterator declaration
clause, the iterator declaration clause must also contain an implements clause
that specifies the sqlj.runtime.ForUpdate interface.
v If you do not customize your SQLJ program, the JDBC driver ignores the value
of holdability that is in the with clause. Instead, the driver uses the JDBC driver
setting for holdability.
Related concepts
“SQLJ and JDBC in the same application” on page 139
Related tasks
“Connecting to a data source using SQLJ” on page 103
“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
284 Application Programming Guide and Reference for Java
™
To Next Page
Loading...
Need help?
General