|
From: Robert M. <rob...@gm...> - 2011-08-10 11:19:40
|
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 <ji...@ho...> 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: rob...@gm... > To: ji...@ho... > CC: squ...@li... > 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 <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 > > > > ------------------------------------------------------------------------------ > 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 > |
