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.