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