Unsupported modifiers
Some modifiers for CREATE PROCEDURE and CREATE FUNCTION are not supported in this version of the database server.
HCL Informix® UDRs
do not support the following routine modifiers of the SQLJ specification.
| Modifier | How to handle the modifier |
|---|---|
| Read SQL data | No Informix® equivalent |
| Contains SQL | No Informix® equivalent |
| Modifies SQL data | No Informix® equivalent |
| No SQL | No Informix® equivalent |
| Return null on null input | Informix® default for external routines |
| Call on null input | Use the Informix® modifier HANDLESNULLS |
| Deterministic | Use the Informix® modifier NOT VARIANT |
| Nondeterministic | Use the Informix® modifier VARIANT |
| Returns Java™ data type in Java™ method signature | No Informix® equivalent |
| In parameter | Informix® default; no need to specify the modifier |