Creating Procedures

To create an SAP Sybase IQ procedure, use the SQL statement CREATE PROCEDURE.

Prerequisites

You must have the CREATE PROCEDURE or CREATE ANY PROCEDURE system privilege.

Task

Enter a CREATE PROCEDURE statement.

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

Note: Use the AT location-string SQL syntax of CREATE PROCEDURE to create a proxy stored procedure.