java.sql.DatabaseMetaData methods supported
The DatabaseMetaData interface provides comprehensive information about the database as a whole.
The following methods are supported by the IMS JDBC drivers for the DatabaseMetaData interface.
| JDBC method | IMS Universal JDBC driver and IMS Universal JCA/JDBC driver support |
|---|---|
| allProceduresAreCallable() | Yes |
| allTablesAreSelectable() | Yes |
| dataDefinitionCausesTransactionCommit() | Yes |
| dataDefinitionIgnoredInTransactions() | Yes |
| deletesAreDetected(int type) | Yes |
| doesMaxRowSizeIncludeBlobs() | Yes |
| getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) | Yes |
| getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) | Yes |
| getCatalogs() | Yes A second column, TIMESTAMP, is added to the returned Resultset object as a String that represents the PSB timestamp. |
| getCatalogSeparator() | Yes |
| getCatalogTerm() | Yes |
| getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) | Yes |
| getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | Yes |
| getConnection() | Yes |
| getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) | Yes |
| getDatabaseMajorVersion() | Yes |
| getDatabaseMinorVersion() | Yes |
| getDatabaseProductName() | Yes |
| getDatabaseProductVersion() | Yes |
| getDefaultTransactionIsolation() | Yes |
| getDriverMajorVersion() | Yes |
| getDriverMinorVersion() | Yes |
| getDriverName() | Yes |
| getDriverVersion() | Yes |
| getExportedKeys(String catalog, String schema, String table) | Yes |
| getExtraNameCharacters() | Yes |
| getIdentifierQuoteString() | Yes |
| getImportedKeys(String catalog, String schema, String table) | Yes |
| getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) | Yes |
| getJDBCMajorVersion() | Yes |
| getJDBCMinorVersion() | Yes |
| getMaxBinaryLiteralLength() | Yes |
| getMaxCatalogNameLength() | Yes |
| getMaxCharLiteralLength() | Yes |
| getMaxColumnNameLength() | Yes |
| getMaxColumnsInGroupBy() | Yes |
| getMaxColumnsInIndex() | Yes |
| getMaxColumnsInOrderBy() | Yes |
| getMaxColumnsInSelect() | Yes |
| getMaxColumnsInTable() | Yes |
| getMaxConnections() | Yes |
| getMaxCursorNameLength() | Yes |
| getMaxIndexLength() | Yes |
| getMaxProcedureNameLength() | Yes |
| getMaxRowSize() | Yes |
| getMaxSchemaNameLength() | Yes |
| getMaxStatementLength() | Yes |
| getMaxStatements() | Yes |
| getMaxTableNameLength() | Yes |
| getMaxTablesInSelect() | Yes |
| getMaxUserNameLength() | Yes |
| getNumericFunctions() | Yes |
| getPrimaryKeys(String catalog, String schema, String table) | Yes |
| getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) | Yes |
| getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | Yes |
| getProcedureTerm() | Yes |
| getResultSetHoldability() | Yes |
| getSchemas() | Yes The following columns are added as
column 3, 4, and 5:
|
| getSchemaTerm() | Yes |
| getSearchStringEscape() | Yes |
| getSQLKeywords() | Yes |
| getStringFunctions() | Yes |
| getSuperTables(String catalog, String schemaPattern, String tableNamePattern) | Yes |
| getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) | Yes |
| getSystemFunctions() | Yes |
| getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | Yes |
| getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) | Yes |
| getTableTypes() | Yes |
| getTimeDateFunctions() | Yes |
| getTypeInfo() | Yes |
| getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) | Yes |
| getURL() | Yes |
| getUserName() | Yes |
| getVersionColumns(String catalog, String schema, String table) | Yes |
| insertsAreDetected(int type) | Yes |
| isCatalogAtStart() | Yes |
| isReadOnly() | Yes |
| locatorsUpdateCopy() | Yes |
| nullPlusNonNullIsNull() | Yes |
| nullsAreSortedAtEnd() | Yes |
| nullsAreSortedAtStart() | Yes |
| nullsAreSortedLow() | Yes |
| othersDeletesAreVisible(int type) | Yes |
| othersInsertsAreVisible(int type) | Yes |
| othersUpdatesAreVisible(int type) | Yes |
| ownDeletesAreVisible(int type) | Yes |
| ownInsertsAreVisible(int type) | Yes |
| ownUpdatesAreVisible(int type) | Yes |
| storesLowerCaseIdentifiers() | Yes |
| storesLowerCaseQuotedIdentifiers() | Yes |
| storesMixedCaseIdentifiers() | Yes |
| storesMixedCaseQuotedIdentifiers() | Yes |
| storesUpperCaseIdentifiers() | Yes |
| storesUpperCaseQuotedIdentifiers() | Yes |
| supportsAlterTableWithAddColumn() | Yes |
| supportsAlterTableWithDropColumn() | Yes |
| supportsANSI92EntryLevelSQL() | Yes |
| supportsANSI92FullSQL() | Yes |
| supportsANSI92IntermediateSQL() | Yes |
| supportsBatchUpdates() | Yes |
| supportsCatalogsInDataManipulation() | Yes |
| supportsCatalogsInIndexDefinitions() | Yes |
| supportsCatalogsInPrivilegeDefinitions() | Yes |
| supportsCatalogsInProcedureCalls() | Yes |
| supportsCatalogsInTableDefinitions() | Yes |
| supportsColumnAliasing() | Yes |
| supportsConvert() | Yes |
| supportsConvert(int fromType, int toType) | Yes |
| supportsCoreSQLGrammar() | Yes |
| supportsCorrelatedSubqueries() | Yes |
| supportsDataDefinitionAnd DataManipulationTransactions() | Yes |
| supportsDataManipulationTransactionsOnly() | Yes |
| supportsDifferentTableCorrelationNames() | Yes |
| supportsExpressionsInOrderBy() | Yes |
| supportsExtendedSQLGrammar() | Yes |
| supportsFullOuterJoins() | Yes |
| supportsGetGeneratedKeys() | Yes |
| supportsGroupByBeyondSelect() | Yes |
| supportsGroupByUnrelated() | Yes |
| supportsIntegrityEnhancementFacility() | Yes |
| supportsLikeEscapeClause() | Yes |
| supportsLimitedOuterJoins() | Yes |
| supportsMinimumSQLGrammar() | Yes |
| supportsMixedCaseIdentifiers() | Yes |
| supportsMixedCaseQuotedIdentifiers() | Yes |
| supportsMultipleOpenResults() | Yes |
| supportsMultipleResultSets() | Yes |
| supportsMultipleTransactions() | Yes |
| supportsNamedParameters() | Yes |
| supportsNonNullableColumns() | Yes |
| supportsOpenCursorsAcrossCommit() | Yes |
| supportsOpenCursorsAcrossRollback() | Yes |
| supportsOpenStatementsAcrossCommit() | Yes |
| supportsOpenStatementsAcrossRollback() | Yes |
| supportsOrderByUnrelated() | Yes |
| supportsOuterJoins() | Yes |
| supportsPositionedDelete() | Yes |
| supportsPositionedUpdate() | Yes |
| supportsResultSetConcurrency(int type, int concurrency) | Yes |
| supportsResultSetHoldability(int holdability) | Yes |
| supportsResultSetType(int type) | Yes |
| supportsSavepoints() | Yes |
| supportsSchemasInDataManipulation() | Yes |
| supportsSchemasInIndexDefinitions() | Yes |
| supportsSchemasInPrivilegeDefinitions() | Yes |
| supportsSchemasInProcedureCalls() | Yes |
| supportsSchemasInTableDefinitions() | Yes |
| supportsSelectForUpdate() | Yes |
| supportsStatementPooling() | Yes |
| supportsStoredProcedures() | Yes |
| supportsSubqueriesInComparisons() | Yes |
| supportsSubqueriesInExists() | Yes |
| supportsSubqueriesInIns() | Yes |
| supportsSubqueriesInQuantifieds() | Yes |
| supportsTableCorrelationNames() | Yes |
| supportsTransactionIsolationLevel(int level) | Yes |
| supportsTransactions() | Yes |
| supportsUnion() | Yes |
| supportsUnionAll() | Yes |
| updatesAreDetected(int type) | Yes |
| usesLocalFilePerTable() | Yes |
| usesLocalFiles() | Yes |