User-defined functions are a class of procedures that return a single value to the calling environment.
SQL Anywhere does not make any assumptions about whether user-defined functions are thread-safe. This is the responsibility of the application developer.
The CREATE FUNCTION syntax differs slightly from that of the CREATE PROCEDURE statement.
No IN, OUT, or INOUT keywords are required, as all parameters are IN parameters.
The RETURNS clause is required to specify the data type being returned.
The RETURN statement is required to specify the value being returned.
Named parameters are not supported.
Creating a user-defined function
Calling a user-defined function
Dropping a user-defined function (SQL)
Granting the ability to execute a user-defined function (SQL)
Advanced information about user-defined functions
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|