Creating a SQL Anywhere or Sybase IQ User-Defined Function

Use Database Development to create your own functions for SQL Anywhere or Sybase IQ.

1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the tree for a database, expand the Schemas folder and then the tree for the appropriate schema owner.
2. Right-click the User Defined Functions folder, and select New > User Defined Function .
3. Enter the new function Name.
4. Specify the SQL type you are using.

   SQL Type	Description
   Watcom-SQL	Choose either Deterministic Function or On Exception Resume. A function specified as not deterministic is re-evaluated each time it is called in a query.
   Transact-SQL	Select On Exception Resume, which enables Transact SQL-like error handling to be used within a Watcom-SQL syntax procedure.

5. Select the Return Data datatype.
6. (Optional) Enter a description in the Comments field.
7. Click Next.
8. Enter a parameter Name.
9. Select a Datatype.
10. Specify any optional default value for the parameter you are defining.
11. Declare variables, or click Finish.
12. In the Name column, enter any local variable names that you want to declare.
13. Select a Datatype.
14. Click Next and specify save and execution properties.

    Field	Description
    Generate Script	Generate a SQL file for the object.
    Enter or Select the Parent Folder	Specify an existing project or create a new project in which to save the SQL file.
    File Name	Enter the file name in which to store the SQL code.
    Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must complete execution of the SQL file later to create the object.
    Open in Editor After Creation	Create the object and open it in its associated editor.

15. Click Finish to create the user-defined function.

---

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com