ADDS36TBL - Add S/36 flat file table

Non-externally defined tables, such as System 36 (S/36) flat files, do not have an external definition that can be accessed directly.

There are two steps to adding S/36 flat files to the Management Console catalog:

1. Issuing this command.
2. Defining the columns of the table that you are adding.

You can define the columns of the table that you are adding through the Define Columns for Non-Externally Defined Table screen that is automatically displayed after you have issued this command.

To define the columns of the table, you need to know the data structure of the S/36 flat file including the sequence, data type, start position, and length of each column. CDC Replication does not perform any error checking to compare the entered file field format with the actual data in the S/36 flat file. After defining the columns, the S/36 flat file is then added to the Management Console catalog. At this point, you cannot modify the field structure of the catalog table, for example, by invoking the Management Console re-add function. If you need to re-define the file format after the table has been added to the Management Console catalog, you must delete the table from the catalog, and then manually re-add the S/36 flat file back to the Management Console catalog using this command. You cannot use the Management Console re-add function to re-define the table structure.

Applies To—Source