Words and Phrases
Existing array mapping
Suppose you want to remap 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 hpeoperator.
The existing array might be mapped as follows on a Microsoft SQL Server RDBMS.
| 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.
| 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.
Related concepts
Existing array query performance
Prepare to remap the array
New array mapping
New array query performance
