Use the Run Options window to specify values for input parameters before running an SQL or SPL procedure or function. You can also specify scripts to run before or after the routine is run.
You can also use the Run Options window to specify values for
input parameters when you are debugging an SQL procedure.
To open the Run Options window:
- In the Server Explorer under your data connection, right-click the routine that you want to run, and then select Run on the shortcut menu.
- In the Server Explorer, right-click the procedure that you want to debug, and then select Step Into on the shortcut menu.
- In the Server Explorer, right-click the procedure that you want to generate an XAML application from, and then select Generate XAML Application on the shortcut menu.
- In the Result Set Definitions window, click Discover.
-
Collection ID (DB2® for z/OS®)
- In the list, select the name of the package collection to use when running the SQL procedure.
- Commit after run
- If True is selected, commits the SQL procedure or function to the database after the routine runs.
- Pre-run script
- Specify the code for the script that you want to run before the routine runs.
- Parameters List
- Lists the Input and InputOutput parameters for the routine.
- Name
- The name of the parameter.
- DataType
- The data type of the parameter.
- Mode
- Indicates whether the parameter is used only for input, or for both input and output.
- Null
- If this check box is selected, the parameter will have a null value when the routine runs. If you want to specify a value for a parameter, clear its check box.
- Value
- Specify the value that you want the parameter to have
when the routine runs. To enter a value, clear the
corresponding Null check box, and then double-click
or press F2 in this cell.
If the data type of a parameter is CLOB, when you click its Value cell, the
button is displayed. Either type a value in the
cell or click the button and select a file to use as
the parameter value for the CLOB.
If the data type of a parameter is BLOB,
when you click its Value cell, the
button is displayed. Either type a value in the
cell or click the button and select a file to use as
the parameter value for the BLOB.
If the data type of a parameter is XML, when you click
its Value cell, the
button is displayed.
Click the button, and then in the Open window, select
the file whose content provides the XML value for the
parameter. Version 9.7 for
Linux®, UNIX®, and
Windows®, or later: If a parameter is an array
data type, when you click its Value cell, the
button is displayed.
Click the button, and then in the
Specify Array
Values window, enter values for the array.
- Post-run script
- Specify the code for the script that you want to run after the routine runs.
- Run
- Runs the routine with the parameter values that you specify.
This button is shown only when you open the Run Options window through the Run command on a routine shortcut menu.
- Step Into
- Runs the procedure in debug mode with the parameter values that
you specify.
This button is shown only when you open the Run Options window through the Step Into command on a procedure shortcut menu.
- Discover
- Runs the procedure to discover the result set with the parameter
values that you specify.
This button is shown only when you open the Run Options window through the Discover button in the Result Set Definitions window.
See Also
Running Procedures or Functions | IBM Data Designer | Array Parameters in DB2 SQL Procedures
.NET Development Forum DB2 FAQs IDS FAQs
© Copyright IBM Corporation 2002, 2019. All Rights Reserved.