Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. POWERCENTERHELP
  17. Session Properties Reference
  18. Workflow Properties Reference

Configuring Fixed-Width Properties

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
Enter the character you want the Integration Service to use to represent null values. You can enter any valid character in the file code page.
Repeat Null Character
Select this option to indicate a null value by repeating the null character to fill the field. If you do not select this option, the Integration Service enters a single null character at the beginning of the field to represent a null value.
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.