Default Rules

COBOL file name	RDBMS table
COBOL record	table row
COBOL field	table column
COBOL key	table index

Redefines are allowed only for the entire record and must be redirected to a different RDBMS table (See WHEN Directive).

FILLER data items are not mapped to table columns. You can overwrite this behavior using the NAME Directive in order to associate a column name with COBOL FILLER.

Cobol group items are not mapped to table columns, instead they are mapped to elementary fields of the group. You can change this approach using the USE GROUP Directive.

There is not a corresponding RDBMS table definition for the COBOL OCCURS statement. For this reason the default behavior is to append a sequential number to the field name. For example:

01 myoccurs occurs 10 times.     03 customer-code pic 9(5).     03 customer-name pic x(30).

Will be mapped in RDBMS as

customer_code_1 customer-name_1 … … customer_code_3 customer-name_3 customer_code_4 customer-name_4 customer_code_5 customer-name_5 ... ...