Fwd: SQL Question , V7 and V8 difference ?

Ravikumar Devireddy

Fwd: SQL Question , V7 and V8 difference ?

Folks,

My apologies for sending it too soon...without
checking the obvious first..!
i checked and see that syscat.indexes does not have a
column 'TBSPACEID' in Db2 V7.
This column is added in V8.

Thanks,
Ravi.
Note: forwarded message attached.




__________________________________
Do you Yahoo!?
The all-new My Yahoo! - Get yours free!
http://my.yahoo.com


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
Attachments

  • import1 (1.5k)

James Campbell

Re: SQL Question , V7 and V8 difference ?
(in response to Ravikumar Devireddy)
What about "TBSPACEID is not a column in the V7 view"?

James Campbell

On Tue, 28 Dec 2004 11:30:38 -0800, Ravi Reddy <[login to unmask email]> wrote:

>Hello,
>
>DB2 UDB on AIX.
>
>Iam unable to run this particular query on DB2 V7
>system :
>
>db2 "SELECT a.tbspaceid tbl_tbsid, b.tbspaceid
>ind_tbsid, count(distinct a.tabname) num_tbl,
>count(distinct b.indname) num_ind FROM syscat.tables a
>LEFT JOIN syscat.indexes b ON a.tabname = b.tabname
>WHERE a.type='T' GROUP BY a.tbspaceid, b.tbspaceid"
>
>Error : SQL0206N "B.TBSPACEID" is not valid in the
>context where it is used.
>SQLSTATE=42703
>
>The same query runs fine on a V8 system,
>Iam unable to figure out what is it that changed from
>V7 to V8 interms of SQL functionality for this
>query...
>
>Any leads please..
>
>Thanks.
>
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm