Creating Procedures
To create an SAP Sybase IQ procedure, use the SQL statement CREATE PROCEDURE.
Altering Procedures
You can modify an existing procedure using either Sybase Control Center or Interactive SQL. You must have the ALTER ANY PROCEDURE system privilege or be the owner of the procedure.
Calling Procedures
CALL statements invoke procedures. Procedures can be called by an application program or by other procedures.
Deleting Procedures
Once you create a procedure, it remains in the database until someone explicitly removes it. Only the owner of the procedure or a user with the DROP ANY PROCEDURE system privilege can drop the procedure from the database.
Returning Procedure Results in Result Sets
In addition to returning results to the calling environment in individual parameters, procedures can return information in result sets. A result set is typically the result of a query.