Rob,
 
That fixed it. Thanks as always.
 
Jim
 

---

Date: Wed, 10 Aug 2011 07:19:33 -0400

From: robert.m.manning@gmail.com
To: jim_it@hotmail.com
CC: squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] DB2 for i/5

Hi Jim,

That could be a configuration issue.  Can you check File -> Global Preferences -> Data Type Controls : Clob (SQL type 2005)

Then select the checkbox that says "Read contents when table is first loaded" and select "all" in the drop-down menu.

Then go back to the tree and refresh it and see if the value for COLUMN_NAME appears.

Rob

On Tue, Aug 9, 2011 at 11:18 PM, Jim It <jim_it@hotmail.com> wrote:

Thanks Rob.
 
I tried both IBM's latest Service Packs for v6r1 and the latest JTOpen driver from SourceForge and both are still displaying <Clob> for COLUMN_NAME field on the Indexes Tab. Is there a SP which is being used to get indexes?
 
I got the SQL statement by retrieving the last SQL statement executed when Indexes Tab was accessed.
 
Jim
 

---

Date: Tue, 9 Aug 2011 20:08:34 -0400
From: robert.m.manning@gmail.com
To: jim_it@hotmail.com
CC: squirrel-sql-users@lists.sourceforge.net
Subject: Re: [Squirrel-sql-users] DB2 for i/5

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

------------------------------------------------------------------------------ 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

------------------------------------------------------------------------------ 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