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
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