Getting Started

Getting Started

Defining a New Database Table, Column or File

Defining a New Database Table, Column or File

A new database table or indexed file needs to be established to hold the SSA-NAME3 Keys and other data. If you are only storing a single key (not recommended), then only a new column or field on an existing table or file needs to be defined. If your database supports a repeating field structure, which can be indexed, this will do, although better performance can be achieved by defining a new table. The size of the SSA-NAME3 Name key field is as you defined in the Algorithm in the previous step (usually either 5-bytes binary or 8-bytes character).
The minimum number of columns or fields in this new table or file is two, the
SSA-NAME3 Key
and a
Record-Id
field to point back to the master record where the name came from. It is recommended, however, that for the sake of good performance, this table be de-normalized to include the name and other identifying data. For more information on this, read Introduction for Application Programmers section in the
INTRODUCTION TO SSA-NAME3 SERVICE GROUPS
guide and the Database Design Notes section in the
APPLICATION REFERENCE FOR SSA-NAME3 SERVICE GROUPS
manual.