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