Parameters in Java routines

Parameter declaration in Java™ routines must conform to the requirements of one of the supported parameter styles.

The following parameter styles are supported for Java routines:
  • PARAMETER STYLE JAVA
  • PARAMETER STYLE DB2GENERAL

It is strongly recommended that you specify the PARAMETER STYLE JAVA clause in the routine CREATE statement. With PARAMETER STYLE JAVA, a routine uses a parameter passing convention that conforms to the Java language and SQLJ Routines specification.

The following list contains the Java routine features that cannot be implemented or used with PARAMETER STYLE JAVA:
  • Table functions
  • Scratchpads in functions
  • Access to the DBINFO structure in functions
  • The ability to make a FINAL CALL (and a separate first call) to a function or method
You can implement features that cannot be implemented or used with PARAMETER STYLE JAVA by creating your routine in C, or parameter style DB2GENERAL.