Server restrictions

This topic describes the restrictions imposed by different versions of the 9.x and later HCL OneDB™ server. It also describes enhancements made to the JDBC driver and the restrictions imposed by it.

Versions 9.2x and 9.3x of have the following requirements and limitations concerning OUT parameters:
  • Only a function can have an OUT parameter. A function is defined as a UDR that returns a value. A procedure is defined as a UDR that does not return a value.
  • There can be only one OUT parameter per function.
  • The OUT parameter has to be the last parameter.
  • You cannot specify INOUT parameters.

    HCL OneDB, Version 10.0, or later allows you to specify INOUT parameters (C, SPL, or Java™ UDRs).

  • The server does not correctly return the value NULL for external functions.
  • You cannot specify OUT parameters that are complex types.
  • You cannot specify C and SPL routines that use the RETURN WITH RESUME syntax.

These restrictions, for server versions 9.2x and 9.3x, are imposed whether users create C, SPL, or Java UDRs.

The functionality of the , Version 9.4 allows:
  • Any parameters to be OUT parameters for C, SPL, or Java UDRs
  • User-defined procedures with no return value to have OUT parameters
  • Multiple OUT parameters

You cannot specify INOUT parameters.

For more information about UDRs, see HCL OneDB User-Defined Routines and Data Types Developer's Guide and HCL® J/Foundation Developer's Guide.