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