Use the SQL Statements page of the New User-Defined Function wizard
to create or import SQL statements for the user-defined function.
- Type of statement
- Specify the type of statement that the user-defined function will run.
- Statement
- Type the SQL statement or SQL expression, or click Create SQL to
open a window where you will be guided through the creation of a SQL statement,
or click Import to import an existing SQL statement.
- Import
- Opens a window so that you can select an SQL statement to import.
- Create SQL
- Opens the SQL Builder so that you can visually construct an SQL statement.
- Parse
- Parses the SQL statement or expression.
- Visual Explain
- Opens Visual Explain, a tool that visually displays a graphical analysis
of the access paths of the selected query.
- Result set
- Specify whether the user-defined function returns a scalar or a table.