What is a Fixed-Width File in DataStage?

 A fixed-width file is a text file where each column has a fixed number of characters. There are no delimiters like commas or pipes.

Example:

101 John 3500

102 Mary 4200

Here:

• ID → 3 characters

• Name → 7 characters

• Salary → 4 characters

How DataStage Reads It:

1. Create a Table Definition with column widths.

2. Use Sequential File Stage.

3. Set Fixed-width as the format.

4. Map each field using exact column size.