Specifying INOUT Parameters for a User-Defined Routine (IDS)

UDRs of Dynamic Server that are written in the SPL, C, or Java languages can also support INOUT parameters. When the UDR is invoked, a value for each INOUT parameter is passed by reference as an argument to the UDR. When the UDR completes execution, it can return a modified value for the INOUT parameter to the calling context. The INOUT parameter can be of any data type that Dynamic Server supports, including user-defined and complex data types.

In the following example, the CREATE PROCEDURE statement registers a C routine that has a single INOUT parameter:

 CREATE PROCEDURE CALC ( INOUT param1 float )
    EXTERNAL NAME "$INFORMIXDIR/etc/myudr.so(calc)"
        LANGUAGE C;

You can assign INOUT parameters to statement-local variables (SLVs), which the section Statement-Local Variable Expressions (IDS) describes.