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.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|