One of the program in my application has the following scenario.
1. I am doing testing in db2 systm DB21. The program in DB21 has an alias of a table, which of another system DB22.
We have done bind successfully. but even though we are getting the sql code -805. plant not found in db22.programname. (this program is subprogram called by the main program). We are using dynamic call of sub programs. All the subprograms and main program is bind in the db2system DB21.
Please help me.