Creating User-Defined Functions

Use the CREATE FUNCTION statement to create user-defined functions.

Prerequisites

You must have the CREATE PROCEDURE system privilege to create functions owned by you.
You must have the CREATE ANY PROCEDURE or CREATE ANY OBJECT system privilege to create functions owned by others.
If the procedure contains an external reference, you must have the CREATE EXTERNAL REFERENCE system privilege, in addition to the above system privileges.

To create a user-defined function in Sybase Control Center, see the Sybase Control Center for SAP Sybase IQ online help in SCC or at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.