Use the Array Types window to select or clear the array data type for the parameter that is selected in the IBM Procedure Designer.
You cannot define array data types in this window. For information about defining array data types, see Creating an array data type (CREATE TYPE statement) in the DB2 Version 9.7 for Linux, UNIX, and Windows, Information Center.
To open the Array Types window:
- In the Procedure Parameters section
of the Procedure view of the designer, select a
parameter, and then click
in the Array Type property cell.
- Defined Array Types
- In the list, select the array data type that you
want to use for the procedure parameter that you
are defining.
- Name
- The defined name of the array type.
- Schema
- The name of the database schema to which the array type is assigned.
- Source Type
- The data type on which the array type is based.
- Length
- The declared fixed length or maximum length of the array type.
- Scale
- The number of digits that are associated with the fractional part of numbers when the array data type is REAL, DOUBLE PRECISION, FLOAT, DECIMAL, or DECFLOAT.
- Array Elements
- The maximum number of elements that can be set as input for the parameter.
- Owner Type
- Indicates whether the array type is system-defined (S) or user-defined (U).
- Clear array type selection
- Select to return the value of the
Array Type property to blank,
which removes the array parameter specification.
Removing the array parameter specification also sets the value of the Array Elements property to 0.
See Also
Array Parameters in DB2 SQL Procedures | Procedure View, IBM Procedure Designer
.NET Development Forum DB2 FAQs
© Copyright IBM Corporation 2002, 2018. All Rights Reserved.