New User-Defined Function wizard - SQL Statement page

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.

Comentarios