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 |