UDB on AIX: Inconsistent display from SYSCAT.TABLES and SYSCAT.COLUMNS

From: Ken Vi (curiosanto@YAHOO.COM.AU)
Date: Thu Oct 31 2002 - 17:34:34 EST

• Next message: Ken Vi: "UDB on AIX: Inconsistent display from SY SCAT.TABLES and SYSCAT.COLUMNS"
• Previous message: Shekhar Dhotre: "Re: AIX fast connect and win2000"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Greetings,

Has anyone come across this inconsistency:

We have a table with 5 cols.

(1) db2 "select colcount from syscat.tables where
tabschema='DB2INST1' and tabname='ABC'"

COLCOUNT
--------
       5

  1 record(s) selected.

(2) db2 "select colname,colno from syscat.columns
where tabschema='DB2INST1' and tabname = 'ABC' order
by colno"

COLNAME COLNO
C1 1
C2 2
C3 3

  3 record(s) selected.

The last 2 cols were added by executing 'ALTER TABLE
ADD..'.

'SELECT * FROM DB2INST1.ABC' also list all 5 cols.

We are on AIX 4.3 and UDB 7.1 fixpack 3.

Any suggestions are welcome.

Thank you,
Curio.

http://careers.yahoo.com.au - Yahoo! Careers
- 1,000's of jobs waiting online for you!

• Next message: Ken Vi: "UDB on AIX: Inconsistent display from SY SCAT.TABLES and SYSCAT.COLUMNS"
• Previous message: Shekhar Dhotre: "Re: AIX fast connect and win2000"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:18 EDT