External Routine Reference:
 
                                             (1)
|--EXTERNAL NAME--| Shared-Object Filename |-------LANGUAGE----->
 
>--+-C----+--+-------------------------------+------------------>
   '-JAVA-'  |                  .-INFORMIX-. |
             '-PARAMETER STYLE--+----------+-'
 
>--+-------------------------------+----------------------------|
   |  (2)    (3)   .-VARIANT-----. |
   '---------------+-NOT VARIANT-+-'
 

1. See Shared-Object Filename
2. C
3. Java

If the IFX_EXTEND_ROLE configuration parameter is set to ON, authorization to use this segment is available only to the Database Server Administrator (DBSA), and to users whom the DBSA has granted the EXTEND role. By default, the DBSA is user informix.

This segment specifies the following information about an external routine:

• Pathname to the executable object code, stored in a shared-object file

  For C routines, this file is either a DLL or a shared library, depending on your operating system.

  For Java routines, this file is a jar file. Before you can create a UDR written in the Java language, you must assign a jar identifier to the external jar file with the sqlj.install_jar procedure. For more information, see sqlj.install_jar.

• The name of the programming language in which the UDR is written
• The parameter style of the UDR

  By default, the parameter style is INFORMIX. (This implies that if you specify OUT or INOUT parameters, the OUT or INOUT values are passed by reference.)

• The VARIANT or NOT VARIANT option, if you specify one. (This option is not available for SPL routines.)