Property Name | Value |
allProceduresAreCallable | false |
allTablesAreSelectable | false |
dataDefinitionCausesTransactionCommit | false |
dataDefinitionIgnoredInTransactions | false |
doesMaxRowSizeIncludeBlobs | false |
getCatalogSeparator | . |
getCatalogTerm | <null> |
getDatabaseMajorVersion | 8 |
getDatabaseMinorVersion | 2 |
getDatabaseProductName | DB2/NT |
getDatabaseProductVersion | SQL08022 |
getDefaultTransactionIsolation | TRANSACTION_READ_COMMITTED |
getDriverMajorVersion | 2 |
getDriverMinorVersion | 6 |
getDriverName | IBM DB2 JDBC Universal Driver Architecture |
getDriverVersion | 2.6.80 |
getExtraNameCharacters | @# |
getIdentifierQuoteString | " |
getJDBCMajorVersion | 3 |
getJDBCMinorVersion | 0 |
getMaxBinaryLiteralLength | 4000 |
getMaxCatalogNameLength | 8 |
getMaxCharLiteralLength | 32672 |
getMaxColumnNameLength | 30 |
getMaxColumnsInGroupBy | 1012 |
getMaxColumnsInIndex | 16 |
getMaxColumnsInOrderBy | 1012 |
getMaxColumnsInSelect | 1012 |
getMaxColumnsInTable | 1012 |
getMaxConnections | 0 |
getMaxCursorNameLength | 18 |
getMaxIndexLength | 1024 |
getMaxProcedureNameLength | 128 |
getMaxRowSize | 32677 |
getMaxSchemaNameLength | 30 |
getMaxStatementLength | 2097152 |
getMaxStatements | 0 |
getMaxTableNameLength | 128 |
getMaxTablesInSelect | 0 |
getMaxUserNameLength | 30 |
getProcedureTerm | stored procedure |
getResultSetHoldability | 1 |
getSchemaTerm | schema |
getSearchStringEscape | \ |
getSQLStateType | 2 |
getURL | jdbc:db2://localhost:50000/sample |
getUserName | dbcopy |
isCatalogAtStart | true |
isReadOnly | false |
locatorsUpdateCopy | true |
nullPlusNonNullIsNull | true |
nullsAreSortedAtEnd | false |
nullsAreSortedAtStart | false |
nullsAreSortedHigh | true |
nullsAreSortedLow | false |
storesLowerCaseIdentifiers | false |
storesLowerCaseQuotedIdentifiers | false |
storesMixedCaseIdentifiers | false |
storesMixedCaseQuotedIdentifiers | false |
storesUpperCaseIdentifiers | true |
storesUpperCaseQuotedIdentifiers | false |
supportsAlterTableWithAddColumn | true |
supportsAlterTableWithDropColumn | false |
supportsANSI92EntryLevelSQL | true |
supportsANSI92FullSQL | false |
supportsANSI92IntermediateSQL | false |
supportsBatchUpdates | true |
supportsCatalogsInDataManipulation | false |
supportsCatalogsInIndexDefinitions | false |
supportsCatalogsInPrivilegeDefinitions | false |
supportsCatalogsInProcedureCalls | false |
supportsCatalogsInTableDefinitions | false |
supportsColumnAliasing | true |
supportsConvert | false |
supportsCoreSQLGrammar | true |
supportsCorrelatedSubqueries | true |
supportsDataDefinitionAndDataManipulationTransactions | true |
supportsDataManipulationTransactionsOnly | false |
supportsDifferentTableCorrelationNames | false |
supportsExpressionsInOrderBy | true |
supportsExtendedSQLGrammar | true |
supportsFullOuterJoins | true |
supportsGetGeneratedKeys | false |
supportsGroupBy | true |
supportsGroupByBeyondSelect | true |
supportsGroupByUnrelated | true |
supportsIntegrityEnhancementFacility | true |
supportsLikeEscapeClause | true |
supportsLimitedOuterJoins | true |
supportsMinimumSQLGrammar | true |
supportsMixedCaseIdentifiers | false |
supportsMixedCaseQuotedIdentifiers | true |
supportsMultipleOpenResults | true |
supportsMultipleResultSets | true |
supportsMultipleTransactions | true |
supportsNamedParameters | false |
supportsNonNullableColumns | true |
supportsOpenCursorsAcrossCommit | true |
supportsOpenCursorsAcrossRollback | false |
supportsOpenStatementsAcrossCommit | true |
supportsOpenStatementsAcrossRollback | true |
supportsOrderByUnrelated | true |
supportsOuterJoins | true |
supportsPositionedDelete | true |
supportsPositionedUpdate | true |
supportsSavepoints | true |
supportsSchemasInDataManipulation | true |
supportsSchemasInIndexDefinitions | true |
supportsSchemasInPrivilegeDefinitions | true |
supportsSchemasInProcedureCalls | true |
supportsSchemasInTableDefinitions | true |
supportsSelectForUpdate | true |
supportsStatementPooling | false |
supportsStoredProcedures | true |
supportsSubqueriesInComparisons | true |
supportsSubqueriesInExists | true |
supportsSubqueriesInIns | true |
supportsSubqueriesInQuantifieds | true |
supportsTableCorrelationNames | true |
supportsTransactions | true |
supportsUnion | true |
supportsUnionAll | true |
usesLocalFilePerTable | false |
usesLocalFiles | false |