IBM DB2 User Manual

Server Driver for JDBC and SQLJ permitted the update or delete operations, but
unexpected updates or deletes might occur.
Starting with version 3.7 and 3.51 of the IBM Data Server Driver for JDBC and
SQLJ, the enableRowsetSupport property enables or disables multi-row FETCH
from DB2 for z/OS tables or DB2 Database for Linux, UNIX, and Windows tables.
The enableRowsetSupport property overrides the useRowsetCursor property. If
multi-row FETCH is enabled through the enableRowsetSupport property, and an
application contains a JDBC 1 positioned update or delete operation, the IBM Data
Server Driver for JDBC and SQLJ throws an SQLException.
Related concepts
“Examples of ResultSetMetaData.getColumnName and
ResultSetMetaData.getColumnLabel values”
Related tasks
“Upgrading the IBM Data Server Driver for JDBC and SQLJ to a new version”
on page 434
Examples of ResultSetMetaData.getColumnName and
ResultSetMetaData.getColumnLabel values
For the IBM Data Server Driver for JDBC and SQLJ version 4.0 and later, the
default behavior of ResultSetMetaData.getColumnName and
ResultSetMetaData.getColumnLabel differs from the default behavior for earlier
JDBC drivers. You can use the useJDBC4ColumnNameAndLabelSemantics property
to change this behavior.
The following examples show the values that are returned for IBM Data Server
Driver for JDBC and SQLJ Version 4.0, and for previous JDBC drivers, when the
useJDBC4ColumnNameAndLabelSemantics property is not set.
All queries use a table that is defined like this:
CREATE TABLE MYTABLE(INTCOL INT)
Example: The following query contains an AS CLAUSE, which defines a label for a
column in the result set:
SELECT MYCOL AS MYLABEL FROM MYTABLE
The following table lists the ResultSetMetaData.getColumnName and
ResultSetMetaData.getColumnName values that are returned for the query:
Table 87. ResultSetMetaData.getColumnName and ResultSetMetaData.getColumnName before and after IBM Data
Server Driver for JDBC and SQLJ Version 4.0 for a query with an AS CLAUSE
Target data source
Behavior before IBM Data Server Driver for
JDBC and SQLJ Version 4.0
Behavior for IBM Data Server Driver for
JDBC and SQLJ Version 4.0 and later
getColumnName
value
getColumnLabel
value
getColumnName
value
getColumnLabel
value
DB2 Database for
Linux, UNIX, and
Windows
MYLABEL MYLABEL MYCOL MYLABEL
IBM Informix
Dynamic Server
MYLABEL MYLABEL MYCOL MYLABEL
Chapter 7. JDBC and SQLJ reference information 379
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

IBM DB2 Specifications

General

Developer	IBM
Initial Release	1983
License	Proprietary
Written in	C, C++
Category	Database Management System (RDBMS)
Operating System	Linux, Windows
Programming Languages	C, C++
Data Models	Relational
Editions	Community, Standard, Advanced
Key Features	high availability, scalability