Workflow Basics Guide

10.5
- 10.4.0

Back Next

Configuring Fixed-Width Properties

When you write data to a fixed-width file, you can edit file properties in the session properties, 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.

In the

Transformations

view on the

Mapping

tab, click the Targets node and then click

Set File Properties

to open the Flat Files dialog box.

To edit the fixed-width properties, select

Fixed Width

and click

Advanced

The following table describes the options you define in the

Fixed Width Properties

dialog box:

Fixed-Width Properties Options	Description
Null Character	Optional. Character that the PowerCenter Integration Service substitutes for null values when it reads null values from a database or a flat file. You can enter any valid character in the file code page.
Repeat Null Character	Optional. Fills null value fields with the character specified in the Null Character option. If you do not select this option, then the PowerCenter Integration Service substitutes each null value with one null character.
Code Page	Optional. 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.

Rename Saved Search

Table of Contents

Workflow Basics Guide

Workflow Basics Guide

Configuring Fixed-Width Properties

Configuring Fixed-Width Properties