User-Defined SQL Functions

Adaptive Server 15.0.2 introduces user-defined SQL functions.

Use create function to create user-defined functions, and drop function to remove a user-defined function.

You can include these elements in a scalar function:
Adaptive Server does not allow fetch statements in a scalar function that return data to the client. You cannot include :

You can include select or fetch statements that assign values only to local variable.