New Stored Procedure wizard - SQL Statement page

Use the SQL Statements page of the New Stored Procedure wizard to create or import SQL statements for the stored procedure.

Statements
Shows the names of the SQL statements that are included in the stored procedure. You can add, remove, or reorder items in this list.
Statement details
Shows the SQL code for the statement that is highlighted in the Statement column. You can modify the SQL code in this field, click Create SQL to open a wizard that will guide you through the process of creating a SQL statement, or click Import to import an existing statement.
Import
Opens a window so that you can select an SQL statement to import.
Show All
Opens a window so that you can view source code for all of the SQL statements in the list.
Create SQL
Opens the SQL Builder so that you can visually construct an SQL statement.
Parse
Parses the SQL statement or expression.
Actual Cost
For stored procedures targeting DB2® for z/OS® only: Opens a window so that you can view actual cost information for the selected query.
Visual Explain
For stored procedures targeting DB2 for Linux®, UNIX®, and Windows® or z/OS only: Opens Visual Explain, a tool that visually displays a graphical analysis of the access paths of the selected query.
Result set
Specify whether the stored procedure returns one result set, multiple result sets, or no result sets.

Comentarios