IBM DB2 User Manual

Table 44. Support for DatabaseMetaData methods (continued)
JDBC method
IBM Data
Server Driver
for JDBC and
SQLJ support
DB2 JDBC
Type 2 Driver
for Linux,
UNIX and
Windows
support
IDS JDBC
Driver support
getTablePrivileges Yes Yes Yes
getTables Yes Yes
10
Yes
10
getTableTypes Yes Yes Yes
getTimeDateFunctions Yes Yes Yes
getTypeInfo Yes Yes Yes
getUDTs No Yes
11
Yes
11
getURL Yes Yes Yes
getUserName Yes Yes Yes
getVersionColumns Yes Yes Yes
insertsAreDetected Yes Yes Yes
isCatalogAtStart Yes Yes Yes
isReadOnly Yes Yes Yes
locatorsUpdateCopy Yes
3
Yes Yes
3
nullPlusNonNullIsNull Yes Yes Yes
nullsAreSortedAtEnd Yes
4
Yes Yes
4
nullsAreSortedAtStart Yes Yes Yes
nullsAreSortedHigh Yes
5
Yes Yes
5
nullsAreSortedLow Yes
1
Yes Yes
1
othersDeletesAreVisible Yes Yes Yes
othersInsertsAreVisible Yes Yes Yes
othersUpdatesAreVisible Yes Yes Yes
ownDeletesAreVisible Yes Yes Yes
ownInsertsAreVisible Yes Yes Yes
ownUpdatesAreVisible Yes Yes Yes
storesLowerCaseIdentifiers Yes
1
Yes Yes
1
storesLowerCaseQuotedIdentifiers Yes
4
Yes Yes
4
storesMixedCaseIdentifiers Yes Yes Yes
storesMixedCaseQuotedIdentifiers Yes Yes Yes
storesUpperCaseIdentifiers Yes
5
Yes Yes
5
storesUpperCaseQuotedIdentifiers Yes Yes Yes
supportsAlterTableWithAddColumn Yes Yes Yes
supportsAlterTableWithDropColumn Yes
1
Yes Yes
1
supportsANSI92EntryLevelSQL Yes Yes Yes
supportsANSI92FullSQL Yes Yes Yes
supportsANSI92IntermediateSQL Yes Yes Yes
supportsBatchUpdates Yes Yes Yes
260 Application Programming Guide and Reference for Java
™

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