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
PD: Does anyone know some good Java Stored Procedures Manual?