If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: DB2 - Execution Of SQLJ and SQLPL procedures

I am new to DB2 environment.. i urgently need your help on the following issues related to the implementation of the Java in DB2

I have queries related to the implementation of SQLJ and SQL/PL of DB2:

In Oracle, PL/SQL (Stored Procedures) code resides in the Database but it seems, in DB2 the code is converted to *.c file and implemented by using *.dll,
1. In DB2, the stored procedure resides inside Database or as dlls?
2. What is the exact usage?

I am confused going through the terms Java Stored Procedures, Java UDF, Java procedures using SQLJ and JDBC, i believe a Java Stored Procedure is same as a procedure written using the embedded SQL (i.e., SQLJ)....
what is the difference exactly...?