Property NameValue
allProceduresAreCallablefalse
allTablesAreSelectablefalse
dataDefinitionCausesTransactionCommitfalse
dataDefinitionIgnoredInTransactionsfalse
doesMaxRowSizeIncludeBlobsfalse
getCatalogSeparator.
getCatalogTerm<null>
getDatabaseMajorVersion8
getDatabaseMinorVersion2
getDatabaseProductNameDB2/NT
getDatabaseProductVersionSQL08022
getDefaultTransactionIsolationTRANSACTION_READ_COMMITTED
getDriverMajorVersion2
getDriverMinorVersion6
getDriverNameIBM DB2 JDBC Universal Driver Architecture
getDriverVersion2.6.80
getExtraNameCharacters@#
getIdentifierQuoteString"
getJDBCMajorVersion3
getJDBCMinorVersion0
getMaxBinaryLiteralLength4000
getMaxCatalogNameLength8
getMaxCharLiteralLength32672
getMaxColumnNameLength30
getMaxColumnsInGroupBy1012
getMaxColumnsInIndex16
getMaxColumnsInOrderBy1012
getMaxColumnsInSelect1012
getMaxColumnsInTable1012
getMaxConnections0
getMaxCursorNameLength18
getMaxIndexLength1024
getMaxProcedureNameLength128
getMaxRowSize32677
getMaxSchemaNameLength30
getMaxStatementLength2097152
getMaxStatements0
getMaxTableNameLength128
getMaxTablesInSelect0
getMaxUserNameLength30
getProcedureTermstored procedure
getResultSetHoldability1
getSchemaTermschema
getSearchStringEscape\
getSQLStateType2
getURLjdbc:db2://localhost:50000/sample
getUserNamedbcopy
isCatalogAtStarttrue
isReadOnlyfalse
locatorsUpdateCopytrue
nullPlusNonNullIsNulltrue
nullsAreSortedAtEndfalse
nullsAreSortedAtStartfalse
nullsAreSortedHightrue
nullsAreSortedLowfalse
storesLowerCaseIdentifiersfalse
storesLowerCaseQuotedIdentifiersfalse
storesMixedCaseIdentifiersfalse
storesMixedCaseQuotedIdentifiersfalse
storesUpperCaseIdentifierstrue
storesUpperCaseQuotedIdentifiersfalse
supportsAlterTableWithAddColumntrue
supportsAlterTableWithDropColumnfalse
supportsANSI92EntryLevelSQLtrue
supportsANSI92FullSQLfalse
supportsANSI92IntermediateSQLfalse
supportsBatchUpdatestrue
supportsCatalogsInDataManipulationfalse
supportsCatalogsInIndexDefinitionsfalse
supportsCatalogsInPrivilegeDefinitionsfalse
supportsCatalogsInProcedureCallsfalse
supportsCatalogsInTableDefinitionsfalse
supportsColumnAliasingtrue
supportsConvertfalse
supportsCoreSQLGrammartrue
supportsCorrelatedSubqueriestrue
supportsDataDefinitionAndDataManipulationTransactionstrue
supportsDataManipulationTransactionsOnlyfalse
supportsDifferentTableCorrelationNamesfalse
supportsExpressionsInOrderBytrue
supportsExtendedSQLGrammartrue
supportsFullOuterJoinstrue
supportsGetGeneratedKeysfalse
supportsGroupBytrue
supportsGroupByBeyondSelecttrue
supportsGroupByUnrelatedtrue
supportsIntegrityEnhancementFacilitytrue
supportsLikeEscapeClausetrue
supportsLimitedOuterJoinstrue
supportsMinimumSQLGrammartrue
supportsMixedCaseIdentifiersfalse
supportsMixedCaseQuotedIdentifierstrue
supportsMultipleOpenResultstrue
supportsMultipleResultSetstrue
supportsMultipleTransactionstrue
supportsNamedParametersfalse
supportsNonNullableColumnstrue
supportsOpenCursorsAcrossCommittrue
supportsOpenCursorsAcrossRollbackfalse
supportsOpenStatementsAcrossCommittrue
supportsOpenStatementsAcrossRollbacktrue
supportsOrderByUnrelatedtrue
supportsOuterJoinstrue
supportsPositionedDeletetrue
supportsPositionedUpdatetrue
supportsSavepointstrue
supportsSchemasInDataManipulationtrue
supportsSchemasInIndexDefinitionstrue
supportsSchemasInPrivilegeDefinitionstrue
supportsSchemasInProcedureCallstrue
supportsSchemasInTableDefinitionstrue
supportsSelectForUpdatetrue
supportsStatementPoolingfalse
supportsStoredProcedurestrue
supportsSubqueriesInComparisonstrue
supportsSubqueriesInExiststrue
supportsSubqueriesInInstrue
supportsSubqueriesInQuantifiedstrue
supportsTableCorrelationNamestrue
supportsTransactionstrue
supportsUniontrue
supportsUnionAlltrue
usesLocalFilePerTablefalse
usesLocalFilesfalse