Input tab Format tab

The Format tab is similar in structure to the Properties tab. A flat file has a number of properties for which you can set different attributes. Select the property in the tree and select the attributes you want to set from the Available properties to add window, it will then appear as a dependent property in the property tree and you can set its value as required. This tab sets the format information for the file at row level. You can override the settings for individual columns using the Edit Column Metadata window.

Click Load to load the format information from a table definition in the metadata repository.

The shortcut menu from the property tree gives access to the following functions:

• Format as. This applies a predefined template of properties. Choose from the following properties:
  • Delimited/quoted
  • Fixed-width records
  • UNIX line terminator
  • DOS line terminator
  • No terminator (fixed width)
  • Mainframe (COBOL)
• Add sub-property. Gives access to a list of dependent properties for the currently selected property (visible only if the property has dependents).
• Set to default. Appears if the currently selected property has been set to a non-default value, allowing you to re-select the default.
• Remove. Removes the currently selected property. This is disabled if the current property is mandatory.
• Remove all. Removes all the non-mandatory properties.