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.