Assimilation › Editing i OS Physical File Format Entries

Editing i OS Physical File Format Entries

CA 2E stores default file format entries for fields on an assimilated file, including:

• sequence of the field
• implementation name of the field on the physical file or the SQL column name on the table
• i OS data type of the field
• length of the field

You can view and change all of these defaults using the Edit Physical File Format Entry panel, which is available only for assimilated files. To access this panel:

1. Zoom into the assimilated file from the Edit Database Relations panel. The Edit File Details panel displays.
2. Zoom into the PHY access path of the file. The Edit Access Path Details displays.
3. Zoom into the access path format entries. The Edit Access Path Format Entries panel displays.
4. Press F8 to get the physical file entries. The Edit Physical File Format Entry panel displays.

This panel enables you to enter and maintain details about the fields that belong to the format of an assimilated physical file. It shows the name and type of format. If adding a relation causes a mismatch between the sequence of fields defined to CA 2E and the existing physical file, change the sequence number defined on the Edit Physical File Format Entry panel. For example, if a Known by relation causes the field to be defined as one of the first fields in the file, change the sequence number defined on the Edit Physical File Format Entry panel.