Conventions for developing Java routines

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:

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.

Feedback