Sequential File Outputs page - Format tab

Use the Format tab to define the format of the data in the file.

This tab has the following controls:

Fixed-width columns: Specifies that the data is extracted from the file in fixed-width columns. The width of each column is specified by the SQL display size (set in the Display column in the columns grid).

First line is column names: Specifies that the first row of data in the file contains the column names. This option is cleared by default, that is, the first row in the file contains data.

Missing columns action: Specifies the action to take when a column is missing from the input data.

Suppress row truncation warnings: Blocks warning messages about overlong rows during run time. This option is helpful if the source file contains more columns than what is defined on the Columns tab.

Wait for writer timeout: Specifies how long the stage waits for a connection when writing to a pipe before the stage times out. Recommended values are between 30 and 600 seconds. If the stage times out, an error is raised and the job is terminated.
This field is displayed only if you selected Stage uses named pipes on the Stage page.

Read timeout: Specifies how long the stage attempts to read data from a pipe before the stage times out. Recommended values are from 30 to 600 seconds. If the stage times out, an error is raised and the job is terminated.
This field is displayed only if you selected Stage uses named pipes on the Stage page.

Delimiter: Contains the delimiter that separates the data fields in the file. By default this field contains a comma. You can specify a single printable character or a decimal or hexadecimal number to represent the ASCII code for the character that you want to use. Valid ASCII codes are in the range of 1 to 253. Decimal values of 1 through 9 must be preceded with a zero. Hexadecimal values must be prefixed with &h. Specify 000 to suppress the delimiter.
This field is available only if you do not select the Fixed-width columns check box.

Quote character: Contains the character that is used to enclose strings. By default this field contains a double quotation mark. You can specify a single printable character or a decimal or hexadecimal number to represent the ASCII code for the character that you want to use. Valid ASCII codes are in the range of 1 to 253. Decimal values of 1 through 9 must be preceded with a zero. Hexadecimal values must be prefixed with &h. Specify 000 to suppress the quote character.
This field is available only if you do not select the Fixed-width columns check box.

Spaces between columns: Specifies the number of spaces that are used between columns. This field is available only if you select the Fixed-width columns check box.

Default NULL string: Contains the characters that are interpreted as the SQL null value when a file is read. You can override this setting for individual column definitions on the Columns tab.

Default padding: Contains the character that is used to pad missing columns. This character is # by default, but you can specify another character to apply to all columns, or you can override this character for individual column definitions on the Columns tab.

Load: Opens the Table Definitions window. Use this window to load column definitions from a table in the repository.