Functions Wizard (Sybase ASE)
Go Up to Sybase ASE Object Wizards
The Functions Wizard creates and submits a CREATE FUNCTION command. This lets you create a user-defined function, a saved Transact-SQL routine that returns a specified value. The wizard collects basic identifying information and generates basic CREATE FUNCTION statement syntax, letting you provide the body of the function.
- Note: This functionality is supported for Sybase ASE 12.5.
To create a new function using a wizard:
- Open a creation wizard for a function. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Functions (SQL Server) - Properties.
- Definition panel - for details, see Functions (SQL Server) - Definition.
- Finally, use the Execute button to create the object.
Functions (Sybase ASE) - Properties
When creating or editing a function, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
|
Owner |
Select the owner of the function. |
|
Name |
Provide a name for the function. |
Functions (Sybase ASE) - Definition
Complete the CREATE FUNCTION outline provided by typing or pasting the body of the function.