Expanding DDL Settings

For a NonStop Enscribe database, define the following settings for the data definition language (DDL).

Setting	Value
Include Redefined Columns	Controls whether redefined fields are included in the field selection. The default is to include redefined fields. Including redefinitions causes a column to be output for every elementary field item in the source definition, regardless of whether or not it redefines another field. To exclude redefined columns, clear the Use Default check box, then activate the Value check box.
Resolve Duplicate Field Names By Appending	Controls whether redundant field names are made unique by appending an index. The default is not to change redundant field names. To append an index, clear the Use Default check box, then select one of the following. Index: Appends an occurrence index number to the end of the field. For example, END-DATE.YY would by default become YY-2 if it is the second occurrence of YY in the definition. (You can change the separator and occurrence padding.) Alpha Index: Appends an occurrence alpha character index (from A to Z) to the end of the field. For example, BEGIN-DATE.MM would become MM-A. Only elementary field names are changed.
Resolve Duplicate Field Names By Prepending Group Name	Controls whether redundant field names are made unique by preceding the field name with the group name. The default is not to change redundant field names. To prepend a group name, clear the Use Default check box, then activate the Value check box. The field name will be preceded with the group name, using the first non-redundant group above the elementary item. Only elementary field names are changed. For example, `END-DATE.DATE-DEF.YY` would become `END-DATE-YY` (DATE-DEF is omitted).
Expand Group Arrays	Controls how Oracle GoldenGate Veridata handles fields that do not necessarily occur multiple times, but which are part of groups that occur multiple times. The default is to do nothing. To append indexes to those field names, clear the Use Default check box, then activate the Value check box. For example, given the following definition, B within the second occurrence of A becomes B-2. The third occurrence of Y within the fourth occurrence of X becomes Y-4-3. 03 A OCCURS 2 TIMES. 04 B PIC 9(5). 03 X OCCURS 2 TIMES. 04 Y PIC 9(5) OCCURS 2 TIMES.
Fix Long Names	Controls whether new names are created for fields that exceed the maximum length of either 120 (default) or a value specified with Maximum Column Name Length. To create new names, clear the Use Default check box, then activate the Value check box.
Maximum Column Name Length	Controls the maximum allowable column length. The default is 120. To change the value, clear the Use Default check box, then activate the Value check box. Default value is 120.
Character To be Used As Separator Between Field Name And Occurrence	Controls the separator character that is placed between a field name and its occurrence. To select a different separator or no separator, clear the Use Default check box, then select Brackets, Dash, Underscore, or Double Underscore, or None. Possible options are: Brackets Dash Underscore Double Underscore None A character separator formats the occurrence as `FIELD[n]`, `FIELD-n`, `FIELD_n`, or `FIELD__ n`. For example, the default of Dash formats the occurrence as shown in the following example. FIELDX FIELDX-1 FIELDX-2 None formats a field and its occurrences as a single field with n occurrences. For example: FIELDX FIELDX FIELDX
Zero Fill Length For Occurrence Indicators	Controls whether occurrence indicators are padded with zeroes to a constant width. The default is not to expand. For example, the seventh occurrence of the field `FLAG` is output as `FLAG-7` (assuming a Dash separator). To pad the occurrence indicators, clear the Default check box and specify a width under Value. For example, a value of 3 pads the seventh occurrence of `FLAG` with two zeroes (`FLAG-OO7`) but does not pad occurrence 423 (`FLAG-423`). Default value is '`0`'.