Hi Team,
SQuirrel SQL clinet 3.7 did not show indentity coumn for the table.
Database is on DB2 LUW 9.7 FP 5, OS AIX
Here are metadata details,
JDBC Driver CLASSNAME com.ibm.db2.jcc.DB2Driver
JDBC Driver CLASSPATH C:\Program Files\IBM\SQLLIB\java\db2jcc.jar;C:\Program Files\IBM\SQLLIB\java\db2jcc4.jar
getURL jdbc:db2://asdeudb12.sdde.deere.com:3702/DDCR2D
isReadOnly false
getUserName appdba2
getDatabaseProductName DB2/AIX64
supportsCatalogsInTableDefinitions false
supportsSchemasInTableDefinitions true
getResultSetHoldability 1
autoCommitFailureClosesAllResultSets <unsupported>
generatedKeyAlwaysReturned <unsupported>
getClientInfoProperties <unsupported>
getRowIdLifetime <unsupported>
supportsStoredFunctionsUsingCallSyntax <unsupported>
getDriverName IBM DB2 JDBC Universal Driver Architecture
getSchemaTerm schema
supportsSchemasInDataManipulation true
supportsCatalogsInDataManipulation false
getDatabaseMajorVersion 9
getIdentifierQuoteString "
getDatabaseProductVersion SQL09075
supportsStoredProcedures true
supportsSavepoints true
getCatalogTerm database
getProcedureTerm stored procedure
supportsMultipleResultSets true
getJDBCMajorVersion 3
getJDBCMinorVersion 0
getCatalogSeparator .
storesMixedCaseIdentifiers false
storesUpperCaseIdentifiers true
supportsCatalogsInProcedureCalls false
supportsDataDefinitionAndDataManipulationTransactions true
supportsMixedCaseQuotedIdentifiers true
storesUpperCaseQuotedIdentifiers false
storesLowerCaseQuotedIdentifiers false
storesMixedCaseQuotedIdentifiers false
supportsAlterTableWithAddColumn true
supportsAlterTableWithDropColumn false
supportsDifferentTableCorrelationNames false
supportsIntegrityEnhancementFacility true
supportsSchemasInProcedureCalls true
supportsSchemasInIndexDefinitions true
supportsSchemasInPrivilegeDefinitions true
supportsCatalogsInIndexDefinitions false
allProceduresAreCallable false
allTablesAreSelectable false
nullsAreSortedHigh true
nullsAreSortedLow false
nullsAreSortedAtStart false
nullsAreSortedAtEnd false
getDriverVersion 3.64.133
getDriverMajorVersion 3
getDriverMinorVersion 64
usesLocalFiles false
usesLocalFilePerTable false
supportsMixedCaseIdentifiers false
storesLowerCaseIdentifiers false
getSearchStringEscape \
getExtraNameCharacters @#
supportsColumnAliasing true
nullPlusNonNullIsNull true
supportsConvert false
supportsTableCorrelationNames true
supportsExpressionsInOrderBy true
supportsOrderByUnrelated true
supportsGroupBy true
supportsGroupByUnrelated true
supportsGroupByBeyondSelect true
supportsLikeEscapeClause true
supportsMultipleTransactions true
supportsNonNullableColumns true
supportsMinimumSQLGrammar true
supportsCoreSQLGrammar true
supportsExtendedSQLGrammar true
supportsANSI92EntryLevelSQL true
supportsANSI92IntermediateSQL false
supportsANSI92FullSQL false
supportsOuterJoins true
supportsFullOuterJoins true
supportsLimitedOuterJoins true
isCatalogAtStart true
supportsPositionedDelete true
supportsPositionedUpdate true
supportsSelectForUpdate true
supportsSubqueriesInExists true
supportsSubqueriesInIns true
supportsCorrelatedSubqueries true
supportsUnionAll true
getMaxBinaryLiteralLength 4000
getMaxCharLiteralLength 32672
getMaxColumnNameLength 128
getMaxColumnsInGroupBy 1012
getMaxColumnsInIndex 16
getMaxColumnsInOrderBy 1012
getMaxColumnsInSelect 1012
getMaxColumnsInTable 1012
getMaxConnections 0
getMaxCursorNameLength 128
getMaxIndexLength 1024
getMaxSchemaNameLength 128
getMaxProcedureNameLength 128
getMaxCatalogNameLength 8
doesMaxRowSizeIncludeBlobs false
getMaxStatementLength 2097152
getMaxStatements 0
getMaxTableNameLength 128
getMaxTablesInSelect 0
getMaxUserNameLength 30
supportsTransactions true
supportsBatchUpdates true
supportsNamedParameters true
supportsMultipleOpenResults true
supportsGetGeneratedKeys true
getDatabaseMinorVersion 7
getSQLStateType 2
locatorsUpdateCopy true
supportsStatementPooling false
getMaxRowSize 32677
supportsUnion true
supportsCatalogsInPrivilegeDefinitions false
supportsSubqueriesInComparisons true
supportsSubqueriesInQuantifieds true
supportsOpenCursorsAcrossCommit true
supportsOpenCursorsAcrossRollback false
supportsOpenStatementsAcrossCommit true
supportsOpenStatementsAcrossRollback true
getDefaultTransactionIsolation TRANSACTION_READ_COMMITTED
supportsDataManipulationTransactionsOnly false
dataDefinitionCausesTransactionCommit false
dataDefinitionIgnoredInTransactions false</unsupported></unsupported></unsupported></unsupported></unsupported>
