You can create user-defined functions from Sybase Central. User-defined functions are a class of procedures that return a single value to the calling environment.
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.
You must have the CREATE EXTERNAL REFERENCE system privilege to create an external function.
No privilege is required to create temporary functions.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, right-click Procedures & Functions and click New » Function.
Follow the instructions in the Create Function Wizard.
In the right pane, click the SQL tab to finish writing the function code.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|