Java™ routines that you build by
using the workbench conform to the SQLJ Routines specification. Java objects are defined in the catalog table
with the LANGUAGE JAVA and PARAMETER STYLE JAVA clauses.
Java objects must follow these rules:
- The method that is mapped to the object must be defined as a public
static void method.
- Output and InOut parameters
must be set up as single element arrays.
An SQL data type of CHAR FOR BIT DATA is mapped to a Java
byte[]. For example:
- IN CHAR(8) FOR BIT DATA maps to byte[] var01
- OUT CHAR(8) FOR BIT DATA maps to byte[][] var02
- INOUT CHAR(8) FOR BIT DATA maps to byte[][] var03
Note: For Java routines, the
routine editor does not support the SQL type ARRAY as an input or
output parameter. If you specify an ARRAY as an input or output parameter,
the routine editor ignores the parameter.