Using the Rotated Array Assistant
The Rotated Array Assistant is a wizard that simplifies the process of creating rotated arrays. The Rotated Array Assistant automatically creates a copy of the selected table and rotates the specified array.
1. Select a table in the CONNX Data Dictionary Manager window.
2. In the Table Columns tab, click Rotate Array.
The Rotated Array Assistant dialog box appears.
3. Double-click an array (or single-click to highlight and click Select Array) to select an array.
4. Enter a New Table Name.
The naming conventions are as follows:
Maximum size is 50 characters.
Table name cannot contain spaces.
Table name cannot begin with a number.
Table name must be unique.
5. Under Array Properties, select the checkboxes that apply:
Array Size Expression defaults to the number of times the array is repeated. For variable length arrays there will be a counter field (possibly ending in _CTR) in the CDD, listing the number of occurrences of the array. Type this field name in the Array Size Expression field. The text box automatically displays the number of occurrences for arrays that have a constant number of occurrences.
Maximum Array Size is the default value.
Create Header Only Record creates a record that includes everything but the rotated arrays. All non-arrayed columns remain.
Include Non-Rotated Arrays in New Record is for small arrays, which are not worth rotating. If left unchecked, only the rotated arrays appear.
Include Nested Arrays includes nested arrays (arrays which contain arrays within themselves).
6. Click Rotate.
The new arrays appear in the CONNX Data Dictionary Manager window.