Querying data on another db2 server

[lawarner]

We have sort of a OLTP and datawarehouse set up on two different db2 servers. I have written a stored procedure that needs to query data from the other db.

Oracle I do select * from table@servername
SQL Server I select * from servername..table

I know the db2 'servername' from the examples below, but I cannot seem to get the syntax.

Thanks from a very new db2 developer!!!

 

[Truusvlugindewind]

http://www.ibm.com/developerworks/db2/library/techarticle/0203haas/0203haas.html

http://users.sdsc.edu/~jrowley/db2/Federated Systems Gd.pdf

 

[Truusvlugindewind]

You're a developer. You'll need those as well:
ftp://ftp.software.ibm.com/ps/products/db2/info/vr6/htm/db2a0/db2a0119.htm#HDRFEDINTRO

http://www.ibm.com/developerworks/db2/library/techarticle/0209saracco/0209saracco1.html

http://www.vldb.org/conf/2006/p1175-kache.pdf

http://www.db2mag.com/shared/printableArticle.jhtml?articleID=12803220

http://www-306.ibm.com/software/data/db2imstools/pdf/db2dpropv81.pdf