Configuring a Rotated Array
To configure a rotated array:
1. Select a table in the upper pane of the CONNX Data Dictionary Manager window.
2. Select Rotated Array under Large Rotated Array Information.
3. Specify the Actual Size of the array. For fixed array sizes, type in the number of elements in the array. If the array size changes depending on another field in the record (a dynamic array), specify that field, or any valid SQL Expression that will determine the size of the array. You may use the following expression to determine the size of the array:
header length + (array element counter (array_CTR) x array element length)
For variable length arrays, the counter field (possibly ending in _CTR, depending on how it was initially set up in RMS and VSAM) appears in the CDD, listing the number of occurrences of the array.
4. The Maximum Size, which equals the total number of elements in the array, is entered automatically, but it can be adjusted. In fixed-length arrays, this number is the same as the actual size.
5. If a Null record is to be returned even when the array size is zero for a particular row, select Return NULL when Size = 0.
6. If the record layout contains more than one variable length array, specify a Dynamic array offset, which is the starting position in the record for this array. This is usually a SQL calculation that adds the length of the fixed portion of the record layout to the size of the preceding variable length arrays. The sizes of the preceding arrays are calculated by multiplying the size of one instance of the array by the number of occurrences of the array.
7. In the Table Columns tab, specify the offset, length, and data type of the first element of the array in the Offset, Length, and DataType columns.
8. Specify the size of one complete element of the array in the Array field. The size is determined by record layout.