Designer Guide

10.4.1
- 10.5.6
- 10.5
- 10.4.0

Back Next

Importing Flat Files without Shift Keys

Use the Flat File Wizard to import a fixed-width file source that does not contain shift keys. However, after you import the source definition, you must define shift states for each column in the file source definition so the Integration Service can read each character correctly.

You can also import shift-sensitive COBOL files that do not contain shift keys. When you do, you must also define the shift states for each column in the COBOL source definition.

When you create a session using a flat file source that contains user-defined shift states, verify that the code page in the Workflow Manager is the same as the code page you chose in the Designer. If you choose a different source code page in the Workflow Manager, the Integration Service does not use the shift keys you defined in the Designer.

To define shift states for fixed-width shift-sensitive files:

In the Designer, import the flat file source or COBOL file.

In the Source Analyzer, double-click the title bar of the file source definition.

In the Flat File Information section of the Table tab, select Fixed Width and click Advanced.

The Edit Flat File Information - Fixed Width Files dialog box appears.

Select User Defined Shift State and click OK.

Click the Columns tab.

The Shift Key column appears.

Choose a shift key for each column.

Choose Shift-In if the column contains single-byte characters. Choose Shift-Out if the column contains multibyte characters.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Importing Flat Files without Shift Keys

Importing Flat Files without Shift Keys