Problem:
=========
Unknown column appearing in federated tables.

Description:
============
Local database (L) is an established 'federated' database, extracting
values from multiple remote databases.
Database server        = DB2/LINUX 7.1.0

Remote (R) database is a new database. Id like L to pull values from
R.
Database server        = DB2/6000 8.1.4

Note the different version numbers.

I can set up the federated configurations on L to R. When building
nicknames additional, and different, columns are appearing in both the
describe and select.

On R
-----
CREATE TABLE application (
Application_id           INTEGER     NOT NULL,
Application_name    VARCHAR(16) NOT NULL
)

On L (having created a nickname)
--------------------------------

Column                Type      Type
name                  schema    name         Length   Scale Nulls
------------------------------ --------- ------------------ --------
APPLICATION_ID        SYSIBM    INTEGER      4     0        No  
APPLICATION_ID0       SYSIBM    INTEGER      4     0        No  
APPLICATION_NAME      SYSIBM    VARCHAR      16    0        Yes

Where has the column APPLICATION_ID0 come from?

Returns back rows with the following columns:
Application_id        OK
Application_id1        ???
Application_id11    ???
Application_id111    ???
Application_name        OK

What are those addition columns?

Works, returning the values found in APPLICATION_ID0 - which isnt in
the APPLICATION table!

fails - which is good.

Im perplexed, this is very odd.
Why Im I obtaining additional columns in the describe?
Why Im I obtaining additional columns in the select? Why are these
different form the view?

Any thoughts are welcome.

Thanks

Terry

KEYWORDS: federated, DB2, columns, additional, 7.1, 8.1, describe,
select