Conversion of variable-length data to fixed-length data

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
gayamantra
Participant
Posts: 1
Joined: Wed Sep 13, 2006 8:56 pm

Conversion of variable-length data to fixed-length data

Post by gayamantra »

Hi,

This is my first time looking at Datastage and I am hoping someone can shed me some light on the following issue.

We have a variable length file that we want to pass to datastage to do some filtering. But can Datastage convert a variable length file to a fixed length format before doing the filtering? Is there functionality in datastage to achieve this?

Will appreciate any comments. Thanks loads in advance!


Gayathri
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. :D
The short answer is yes. Specify delimited format when you're reading, and fixed width format when you're writing.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply