Contents Index Returning results from procedures Returning results as procedure parameters

ASA SQL User's Guide
  Using Procedures, Triggers, and Batches
    Returning results from procedures

Returning a value using the RETURN statement


The RETURN statement returns a single integer value to the calling environment, causing an immediate exit from the procedure. The RETURN statement takes the form:

RETURN expression

The value of the supplied expression is returned to the calling environment. To save the return value in a variable, use an extension of the CALL statement:

CREATE VARIABLE returnval INTEGER ;
returnval = CALL myproc() ;

Contents Index Returning results from procedures Returning results as procedure parameters