Server restrictions
This topic describes the restrictions imposed by different versions of the 9.x and later HCL Informix® 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 Informix®, 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 Informix® User-Defined Routines and Data Types Developer's Guide and J/Foundation Developer's Guide.