Types of updates that the Data interface supports

You can use the Data interface's update() method to perform a single update to a database object and the updateMany() method to perform a batch of updates that are based on a single SQL statement.

The methods support the following types of SQL statements:

You can perform updates only when your Data object is connected to a the data source that corresponds to the SQL statement.

The overloading of the update() method allows you optionally to request information regarding auto-generated columns. When you request this information, you can perform only single-row forms of the types of SQL statements that your database driver supports for auto-generated columns. For example, the IBM® Data Server Driver for JDBC and SQLJ supports the return of keys auto-generated only from INSERT statements.


Feedback