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
supportsCatalogsInDataManipulation Yes
1
Yes Yes
1
supportsCatalogsInIndexDefinitions Yes Yes Yes
supportsCatalogsInPrivilegeDefinitions Yes Yes Yes
supportsCatalogsInProcedureCalls Yes
1
Yes Yes
1
supportsCatalogsInTableDefinitions Yes Yes Yes
SupportsColumnAliasing Yes Yes Yes
supportsConvert Yes Yes Yes
supportsCoreSQLGrammar Yes Yes Yes
supportsCorrelatedSubqueries Yes Yes Yes
supportsDataDefinitionAndDataManipulationTransactions Yes Yes Yes
supportsDataManipulationTransactionsOnly Yes Yes Yes
supportsDifferentTableCorrelationNames Yes
4
Yes Yes
4
supportsExpressionsInOrderBy Yes Yes Yes
supportsExtendedSQLGrammar Yes Yes Yes
supportsFullOuterJoins Yes
3
Yes Yes
3
supportsGetGeneratedKeys Yes No No
supportsGroupBy Yes Yes Yes
supportsGroupByBeyondSelect Yes Yes Yes
supportsGroupByUnrelated Yes Yes Yes
supportsIntegrityEnhancementFacility Yes Yes Yes
supportsLikeEscapeClause Yes Yes Yes
supportsLimitedOuterJoins Yes Yes Yes
supportsMinimumSQLGrammar Yes Yes Yes
supportsMixedCaseIdentifiers Yes Yes Yes
supportsMixedCaseQuotedIdentifiers Yes
3
Yes Yes
3
supportsMultipleOpenResults Yes
5
No Yes
5
supportsMultipleResultSets Yes
5
Yes Yes
5
supportsMultipleTransactions Yes Yes Yes
supportsNamedParameters Yes No No
supportsNonNullableColumns Yes Yes Yes
supportsOpenCursorsAcrossCommit Yes
3
Yes Yes
3
supportsOpenCursorsAcrossRollback Yes Yes Yes
supportsOpenStatementsAcrossCommit Yes
3
Yes Yes
3
supportsOpenStatementsAcrossRollback Yes
3
Yes Yes
3
supportsOrderByUnrelated Yes Yes Yes
supportsOuterJoins Yes Yes Yes
Chapter 7. JDBC and SQLJ reference information 261
To Next Page
Loading...
Need help?
General