Return Clause

The Return clause specifies the data type of a value or values that a user-defined function returns. You can use this segment in UDR definitions.

Syntax

Read syntax diagramSkip visual syntax diagram
Return Clause
Read syntax diagramSkip visual syntax diagramRETURNINGRETURNSSubset of SQL Data Types1REFERENCESBYTETEXTASparameter2,Subset of SQL Data Types1REFERENCESBYTETEXTASparameter
Notes:

Element Description Restrictions Syntax
parameter Name that you declare here for a returned parameter of the UDR Must be unique among returned parameter names of the UDR. If any returned value of the UDR has a name, then all must have names. Identifier

Usage

For compatibility with earlier Informix® releases, you can create SPL functions with the CREATE PROCEDURE statement. (That is, you can include a Return clause in CREATE PROCEDURE statements.) Use CREATE FUNCTION, however, to create new SPL routines that return one or more values.

After the Return clause has indicated what data types are to be returned, you can use the RETURN statement of SPL at any point in the statement block to return SPL variables that correspond to the values in the Return clause.