ASA SQL User's Guide
  Using Procedures, Triggers, and Batches

Returning results from procedures

Procedures can return results in the form of a single row of data, or multiple rows. Results consisting of a single row of data can be passed back as arguments to the procedure. Results consisting of multiple rows of data are passed back as result sets. Procedures can also return a single value given in the RETURN statement.

For simple examples of how to return results from procedures, see Introduction to procedures. For more detailed information, see the following sections.

Returning a value using the RETURN statement
Returning results as procedure parameters
Returning result sets from procedures
Returning multiple result sets from procedures
Returning variable result sets from procedures