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.
- Validate
- 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.