=========
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)
--------------------------------
describe table r_application
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?
select * from r_application
Returns back rows with the following columns:
Application_id OK
Application_id1 ???
Application_id11 ???
Application_id111 ???
Application_name OK
What are those addition columns?
select APPLICATION_ID0 from r_application
Works, returning the values found in APPLICATION_ID0 - which isnt in
the APPLICATION table!
select APPLICATION_ID1 from r_application
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