- PowerCenter 10.4.0
- All Products
Fixed-Width Properties Options
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 of the fixed-width file. Select a code page or a variable:
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.