Adding Real Fields to a Table

The fields in the table are the columns in the table that make up the record format. To complete a basic table definition, you must identify the following:

• What are the columns in the table?

• What is the sequence of these columns?

• What columns are used as the keys to the table?

There are two ways of adding the real fields to a table.

Add Single Field

You may add an existing field in the Repository to a table definition. When the field is added, you can specify if it is a key field and where it is sequenced in the table.

Add Multiple Fields

You can add multiple fields to a table definition. Using this approach, the field does not have to exist in the Repository. You can specify the field characteristics as you add them to the table and they will be created in the Repository once you have completed the list of fields. Again, you can specify if a field is a key to the table. Sequence is based on the order that the fields are added.

Also See

Real Columns in Table in the Technical Reference Guide