ASA SQL User's Guide
Using Procedures, Triggers, and Batches
Returning results from procedures
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() ;