Workflow Basics Guide

10.4.0
- 10.5.6
- 10.5

Back Next

Configuring Fixed-Width File Properties

When you read data from a fixed-width file, you can edit file properties in the session, such as the null character or code page. You can configure fixed-width properties for non-reusable sessions in the Workflow Designer and for reusable sessions in the Task Developer. You cannot configure fixed-width properties for instances of reusable sessions in the Workflow Designer.

Click Set File Properties to open the Flat Files dialog box. To edit the fixed-width properties, select Fixed Width and click Advanced. The Fixed Width Properties dialog box appears. By default, the Workflow Manager displays file properties as configured in the mapping. Edit these settings to override those configured in the source definition.

The following table describes options you can define in the Fixed Width Properties dialog box for file sources:

Fixed-Width Properties Options	Description
Text/Binary	Indicates the character representing a null value in the file. This can be any valid character in the file code page, or any binary value from 0 to 255.
Repeat Null Character	If selected, the Integration Service reads repeat null characters in a single field as a single null value. If you do not select this option, the Integration Service reads a single null character at the beginning of a field as a null field. Important: For multibyte code pages, specify a single-byte null character if you use repeating non-binary null characters. This ensures that repeating null characters fit into the column.
Code Page	Code page of the fixed-width file. Select a code page or a variable: Code page. Select the code page. Use Variable. Enter a user-defined workflow or worklet variable or the session parameter $Param Name , and define the code page in the parameter file. Use the code page name. Default is the PowerCenter Client code page.
Number of Initial Rows to Skip	Integration Service skips the specified number of rows before reading the file. Use this to skip header rows. One row may contain multiple records. If you select the Line Sequential File Format option, the Integration Service ignores this option.
Number of Bytes to Skip Between Records	Integration Service skips the specified number of bytes between records. For example, you have an ASCII file on Windows with one record on each line, and a carriage return and line feed appear at the end of each line. If you want the Integration Service to skip these two single-byte characters, enter 2. If you have an ASCII file on UNIX with one record for each line, ending in a carriage return, skip the single character by entering 1.
Strip Trailing Blanks	If selected, the Integration Service strips trailing blanks from string values.
Line Sequential File Format	Select this option if the file uses a carriage return at the end of each record, shortening the final column.

Rename Saved Search

Table of Contents

Workflow Basics Guide

Workflow Basics Guide

Configuring Fixed-Width File Properties

Configuring Fixed-Width File Properties