Use the SQL Statements page of the New Stored Procedure wizard to create or import SQL statements for the stored procedure. For non-PL/SQL routines.
- 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.