Home | Previous Page | Next Page   Creating Java User-Defined Routines > Complying with SQLJ >

Unsupported Modifiers

Some modifiers for CREATE PROCEDURE and CREATE FUNCTION are not supported in this version of the database server. 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
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]