Define Sequential Metadata window

Use the Define Sequential Metadata window to define the information to be imported from a sequential file.

The window contains the following controls and fields:

Filename: Displays the name and path of the sequential file. You cannot edit this field. If you want to choose an alternative file, click Cancel. The Import Meta data (Sequential) window reappears, use the window to specify a different directory or file.

Fixed-width columns

Select this option to specify that the sequential file contains fixed-width fields.The Fixed-width columnsoption is cleared by default, that is, the file does not contain fixed-width fields. When Fixed-width columns is selected, the Fixed-widthfields becomes available.

Column widths: Enter the width for each column in the field. Widths are entered using the format n,n,n…n where n is the width of the column. You must have an entry for each column in the file.

Spaces between columns: Specify the space between the columns

First line is column names: Select this option to specify that the first data row in the file contains the column names. The First line is column names option is cleared by default. Select this option if the first line contains column names.

Delimited: The options in this area are available only if the Fixed-width columns option is cleared. The option buttons Tab, Space, and Comma (the default) specify how the fields are separated. To specify an alternative separation character, enter it in the Other Delimiter field. If values are quoted, enter the quote character in the Quote Character field. You can enter a number from 0 to 255 in the Other Delimiter or Quote Character fields to represent the ASCII code for the character you want to use.

Data Preview: This grid displays the first 10 rows of data in the chosen file using the options specified on the Format page.

Preview: Click Preview to update the Data Preview grid using the format options you selected in the rest of this window.

Define: Displays the column definition for each column in the file. If the first row in the file contains the column names, these are displayed in the Column name column, otherwise, default column names are assigned. You can edit any of the values in the grid. Note: If you change any of the column definitions in this page, and subsequently return to the Format page before clicking OK, you will lose the changes to the column definitions.