Existing array mapping

Suppose you want to re-map the assignment.groups array field in the operator table from a field in a main table array to a multi-row array table array. To ensure that your tailoring efforts do not negatively impact your system, you should first make a copy of the operator table. For example, create a new table called hpoperator.

The existing array might be mapped as follows on a Microsoft SQL Server RDBMS.

Array mapped as a field in a main table

Existing array field mapping: field in main
Database dictionary field Value
Name assignment.groups
Type array
Level 1
Index 88
SQL Name  
SQL Type  
SQL Table  
SQL RC  

Since this is a field in main table mapping, the array itself has no direct mapping on the RDBMS. Only the array's sub-field has a SQL mapping.

Existing sub-field mapping: field in main
Database dictionary field Value
Name assignment.groups
Type character
Level 2
Index 1
SQL Name ASSIGNMENT_GROUPS
SQL Type TEXT
SQL Table m1
SQL RC False

The sub-field of the array is mapped to a character large object data type. For example, TEXT is a character large object data type in Microsoft SQL Server.