To create an SAP Sybase IQ procedure, use the SQL statement CREATE PROCEDURE.
This example uses the SAP Sybase IQ demo database iqdemo.db.
CREATE PROCEDURE new_dept(IN id INT, IN name CHAR(35), IN head_id INT) BEGIN INSERT INTO GROUPO.departments(DepartmentID, DepartmentName, DepartmentHeadID) values (id, name, head_id); END