Hi:
I'm trying to write a Java Stored procedure on DB2 8.2 for Windows and my problem is as follows.
I need to establish a database connection to a different database to the one the stored procedure is on. Is it possible to do it?. I´ve already tried all I can think about but nothing worked.
The reason I need to access another database is because I need some data stored on it in order to return some values from the actual database where the java procedure is stored.
All ideas will be welcome
Thanks

Juan Pane
PD: Does anyone know some good Java Stored Procedures Manual?

Consider federated database.

regards

Mujeeb