You will have to create a nickname for the remote table and then use the nickname to select ....
Read the federated systems topic in admin guide for detailed info ..
Originally posted by zkajfez
My database is SAMPLE.
I created wrapper named DRDA,and server named ZAPZG.
Now,how I enter some select from table named PROD.A (that table is on server ZAPZG)?
Visit the new-look IDUG Website , register to gain access to the excellent content.