1  RETURN_Control
   Returns the value of the stored function.
 

2  Environment
   You can use the RETURN statement in a compound statement:

   o  In interactive SQL

   o  Embedded in host language programs to be precompiled

   o  As part of a procedure in an SQL module

   o  In dynamic SQL as a statement to be dynamically executed
 

2  Format

 (B)0RETURN qqq> value-expr qqqq>  
                               

 

2  Arguments
 

3  value_expr

   The value expression to be returned as the result of this
   function call. The value-expr must be assignment-compatible with
   the data type defined by the stored function RETURNS clause.

   See Value Expressions for more information on value expressions.
 

2  Examples
   Example 1: Specifying the RETURN statement in a stored function

   SQL> CREATE MODULE utility_functions
   cont>   LANGUAGE SQL
   cont>   FUNCTION abs (IN :arg INTEGER) RETURNS INTEGER
   cont>      COMMENT 'Returns the absolute value of an integer';
   cont>   BEGIN
   cont>      RETURN CASE
   cont>             WHEN :arg < 0 THEN - :arg
   cont>             ELSE :arg
   cont>             END;
   cont>   END;
      .
      .
      .
   cont> END MODULE;