PARAMETER STYLE DB2GENERAL routines are written
in Java™. Creating DB2GENERAL
routines is very similar to creating routines in other supported programming
languages. After you created and registered the routines, you can
call them from programs in any language.
Typically, you can call JDBC APIs from your stored procedures,
but you cannot call them from UDFs.
When developing routines in Java,
it is strongly recommended that you register them using the PARAMETER
STYLE JAVA clause in the CREATE statement. PARAMETER STYLE DB2GENERAL
is still available to enable the implementation of the following features
in Java routines:
- table functions
- scratchpads
- access to the DBINFO structure
- the ability to make a FINAL CALL (and a separate first call) to
the function or method
If you have PARAMETER STYLE DB2GENERAL routines that do not
use any of these features, it is recommended that you port them to
PARAMETER STYLE JAVA.