Use the Specify Array Values window to enter values for an array parameter before you run a procedure. You either can type the array values or you can import a file that contains the values.
You also can export the array values that are shown in the list in this window.
To open the Specify Array Values window:
- In the Parameters List section of
the Run Options window, click
in the
Value cell of an array parameter.
- Index
- Shows the index value for each position in the array.
- Value
- Specify a value that is consistent with the
array data type that is defined for the array
parameter.
If you specify an array value that is inconsistent with the defined array data type, an X character is displayed in the left column of the row.
- Opens the Open window, where you can select
a file that contains the array values to
use for the parameter. You can import array
values that are stored in a file that is one
of the following file types:
- XML - XML result file
- CSV - comma-delimited file
- PSV - pipe-delimited file
- Opens the Save As window, where you can
save the displayed array values to a
file. You can export array values to
one of the following file types:
- XML - XML result file
- CSV - comma-delimited file
- PSV - pipe-delimited file
- Remove All
- Deletes all the rows from the list.
See Also
Running Procedures or Functions | Run Options | Array Parameters in DB2 SQL Procedures
.NET Development Forum DB2 FAQs
© Copyright IBM Corporation 2002, 2018. All Rights Reserved.