User-defined functions are not invoked with the CALL statement, but are used in the same manner that built-in functions are. For example, the following statement uses the FullName function defined in Creating user-defined functions to retrieve the names of employees:
In Interactive SQL, type the following:
SELECT FullName( GivenName, Surname ) AS Name FROM Employees; |
Name |
---|
Fran Whitney |
Matthew Cobb |
Philip Chin |
Julie Jordan |
... |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |