Procedures return results to the calling environment in several
ways.
Individual values are returned as OUT or
INOUT parameters.
As result sets.
A single result can be returned using a
RETURN
statement.
Note: This example uses the SAP Sybase IQ demo database
iqdemo.db.
CREATE PROCEDURE SalaryList (IN department_id INT)
RESULT ( "Employee ID" INT, "Salary" NUMERIC(20,3) )
BEGIN
SELECT EmployeeID, Salary
FROM Employees
WHERE Employees.DepartmentID = department_id;
END