Routine Parameter List

Routine Parameter List:
 
   .-,-----------------------------.
   V                               |
|----+------------+--| Parameter |-+----------------------------|
     +-OUT--------+
     |       (1)  |
     '-INOUT------'
 
Parameter:
 
|--+-parameter-+------------------------------------------------>
   |  (2)      |
   '-----------'
 
                                   (3)
>--+-+-| Subset of SQL Data Type |------+--+----------------+-+--|
   | '-LIKE--table--.--column-----------'  '-DEFAULT--value-' |
   '-REFERENCES--+-BYTE-+--+--------------+-------------------'
                 '-TEXT-'  '-DEFAULT NULL-'

Notes:

Dynamic Server only
External routines only
See Subset of SQL Data Types

Element	Description	Restrictions	Syntax
column	Name of a column whose data type is declared for parameter	Must exist in the specified table	Database Object Name
parameter	Name of a parameter of the UDR	Name is required for SPL routines	Identifier
table	Table that contains column	The table must exist in the database	Identifier
value	Default used if UDR is called with no value for parameter	Must be a literal, of the same data type as parameter. For opaque types, an input function must be defined	Literal Number

A parameter is a formal argument in the declaration of a UDR. (When you subsequently invoke a UDR that has parameters, you must substitute an actual argument for the parameter, unless the parameter has a default value.)

The name of the parameter is optional for external routines of Dynamic Server.

When you create a UDR, you declare a name and data type for each parameter. You can specify the data type directly, or use the LIKE or REFERENCES clause to specify the data type. You can optionally specify a default value.

You can define any number of SPL routine parameters, but the total length of all parameters passed to an SPL routine must be less than 64 kilobytes.

No more than nine arguments to a UDR written in the Java language can be DECIMAL data types of SQL that the UDR declares as BigDecimal data types of the Java language.

Any C language UDR that returns an opaque data type must specify opaque_type in the var binary declaration of the C host variable.

Routine Parameter List

Syntax

Usage