DB2DatabaseMetaData interface

The com.ibm.db2.jcc.DB2DatabaseMetaData interface extends the java.sql.DatabaseMetaData interface.

DB2DatabaseMetaData methods

The following methods are defined only for the IBM® Data Server Driver for JDBC and SQLJ.

getDatabaseFunctionalLevel
Format:
public String getDatabaseFunctionalLevel()
throws java.sql.SQLException

For a new Connection instance, returns the function level or build level of the data server. For a Db2 on Linux®, UNIX, and Windows systems data server, this value is the build level: for example, S1612011300. For a Db2 12 for z/OS® data server with the PTF for APAR PI74456 applied, or later, this value is the function level: for example, V12R1M500. For a data server that does not support function levels, null is returned.

isIDSDatabaseAnsiCompliant
Format:
public boolean isIDSDatabaseAnsiCompliant();

Returns true if the current active IBM Informix® database is ANSI-compliant. Returns false otherwise.

An ANSI-compliant database is a database that was created with the WITH LOG MODE ANSI option.

This method applies to connections to IBM Informix data sources only. An SQLException is thrown if the data source is not an IBM Informix data source.

isIDSDatabaseLogging
Format:
public boolean isIDSDatabaseLogging();

Returns true if the current active IBM Informix database supports logging. Returns false otherwise.

An IBM Informix database that supports logging is a database that was created with the WITH LOG MODE ANSI option, the WITH BUFFERED LOG, or the WITH LOG option.

This method applies to connections to IBM Informix data sources only. An SQLException is thrown if the data source is not an IBM Informix data source.

isResetRequiredForDB2eWLM
Format:
public boolean isResetRequiredForDB2eWLM();

Returns true if the target database server requires clean reuse to support eWLM. Returns false otherwise.

supportsDB2ProgressiveStreaming
Format:
public boolean supportsDB2ProgressiveStreaming();

Returns true if the target data source supports progressive streaming. Returns false otherwise.

getDriverDB2ConnectLevel
Identifies the version of Db2 Connect and the IBM® Data Server Driver for JDBC and SQLJ version that an application is using for a connection to a data server.