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 <jim_it@hotmail.com> 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
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users