Understanding the Terminology › Compound Fields

Compound Fields

CA Datacom/DB provides the ability to give a single column name to a group of contiguous columns and to refer to the group by that name. Each individual column also has a name. This data structure can also be called a compound field.

Compound Field

    ┌─────────────────────┐
    │          NAME       │
    ├──────────┬──────────│──────────┬──────────┐
    │   LAST   │   FIRST  │  CITY    │   STATE  │
    ├──────────│──────────│──────────│──────────┤
    │  SMITH   │   MARY   │ ATLANTA  │  GEORGIA │
    └──────────┴──────────┴──────────┴──────────┘