John Bailo wrote:
> select tabschema, tabname, base_tabschema, base_tabname from
syscat.tables where type = 'A'
SQL State: 42704
Vendor Code: -204
Message: [SQL0204] TABLES in SYSCAT type *FILE not found. Cause . . . .
Then you probably want to tell us on which platform you are running and
which version of DB2 you are using. The above query works quite fine on
DB2 for Linux, Unix and Windows.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany