|
From: Robert M. <rob...@gm...> - 2011-08-10 00:08:41
|
Hi Jim, SQuirreL doesn't use a query for that info - it comes from the JDBC Driver. Perhaps the version of your JDBC driver doesn't support this data type change that IBM made to the data dictionary ? Rob On Tue, Aug 9, 2011 at 4:22 PM, Jim It <ji...@ho...> wrote: > When viewing the Indexes built on a Table, the Column name no longer > displays if the operating system is v6r1 and above. > > IBM changed the DATATYPE for field COLUMN_NAME in table SQLSTATISTICS to > DBCLOB. > > I believe the following SQL statement would work to show the COLUMN_NAME, > regardless of operating version. > > SELECT > TABLE_CAT , > TABLE_SCHEM , > TABLE_NAME , > NON_UNIQUE , > INDEX_QUALIFIER , > INDEX_NAME , > TYPE , > ORDINAL_POSITION , > cast(COLUMN_NAME as varchar(128)) As COLUMN_NAME, > ASC_OR_DESC , > CARDINALITY , > PAGES , > FILTER_CONDITION > FROM SYSIBM . SQLSTATISTICS > WHERE TABLE_SCHEM = ? > AND TABLE_NAME = ? > ORDER BY 4 , 7 , 6 , 8 > > > Thanks, > > Jim > > > ------------------------------------------------------------------------------ > uberSVN's rich system and user administration capabilities and model > configuration take the hassle out of deploying and managing Subversion and > the tools developers use with it. Learn more about uberSVN and get a free > download at: http://p.sf.net/sfu/wandisco-dev2dev > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
