JDBC interfaces for executing SQL - IBM DB2 9.7 for Linux, UNIX, and Windows

Creating and modifying database objects using the Statement.executeUpdate method
The Statement.executeUpdate is one of the JDBC methods that you can use to update tables and call stored procedures.

Updating data in tables using the PreparedStatement.executeUpdate method
The Statement.executeUpdate method works if you update data server tables with constant values. However, updates often need to involve passing values in variables to the tables. To do that, you use the PreparedStatement.executeUpdate method.

JDBC executeUpdate methods against a DB2 for z/OS server
The JDBC standard states that the executeUpdate method returns a row count or 0. However, if the executeUpdate method is executed against a DB2 for z/OS® server, it can return a value of -1.

Making batch updates in JDBC applications
With batch updates, instead of updating rows of a table one at a time, you can direct JDBC to execute a group of updates at the same time. Statements that can be included in the same batch of updates are known as batchable statements.

Learning about parameters in a PreparedStatement using ParameterMetaData methods
The IBM Data Server Driver for JDBC and SQLJ includes support for the ParameterMetaData interface. The ParameterMetaData interface contains methods that retrieve information about the parameter markers in a PreparedStatement object.

Data retrieval in JDBC applications
In JDBC applications, you retrieve data using ResultSet objects. A ResultSet represents the result set of a query.

Calling stored procedures in JDBC applications
To call stored procedures, you invoke methods in the CallableStatement or PreparedStatement class.

LOBs in JDBC applications with the IBM Data Server Driver for JDBC and SQLJ
The IBM Data Server Driver for JDBC and SQLJ supports methods for updating and retrieving data from BLOB, CLOB, and DBCLOB columns in a table, and for calling stored procedures or user-defined functions with BLOB or CLOB parameters.

ROWIDs in JDBC with the IBM Data Server Driver for JDBC and SQLJ
DB2 for z/OS and DB2 for i support the ROWID data type for a column in a database table. A ROWID is a value that uniquely identifies a row in a table.

Distinct types in JDBC applications
A distinct type is a user-defined data type that is internally represented as a built-in SQL data type. You create a distinct type by executing the SQL statement CREATE DISTINCT TYPE.

Invocation of stored procedures with ARRAY parameters in JDBC applications
JDBC applications that run under the IBM Data Server Driver for JDBC and SQLJ can call stored procedures that have ARRAY parameters.

Savepoints in JDBC applications
An SQL savepoint represents the state of data and schemas at a particular point in time within a unit of work. You can use SQL statements to set a savepoint, release a savepoint, and restore data and schemas to the state that the savepoint represents.

Retrieval of automatically generated keys in JDBC applications
With the IBM Data Server Driver for JDBC and SQLJ, you can retrieve automatically generated keys (also called auto-generated keys) from a table using JDBC 3.0 methods.

Named parameter markers in JDBC applications
You can use named parameter markers instead of standard parameter markers in PreparedStatement and CallableStatement objects to assign values to the input parameter markers. You can also use named parameter markers instead of standard parameter markers in CallableStatement objects to register OUT parameters that have named parameter markers.

Providing extended client information to the data source with IBM Data Server Driver for JDBC and SQLJ-only methods
A set of IBM Data Server Driver for JDBC and SQLJ-only methods provide extra information about the client to the server. This information can be used for accounting, workload management, or debugging.

Providing extended client information to the data source with client info properties
The IBM Data Server Driver for JDBC and SQLJ version 4.0 supports JDBC 4.0 client info properties, which you can use to provide extra information about the client to the server. This information can be used for accounting, workload management, or debugging.