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. Session Properties Reference
  17. Workflow Properties Reference

Configuring Fixed-Width File Properties

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.