Delimited file with fixed width

rcil · Post by **rcil** » Sat Mar 12, 2011 10:39 pm

What is the easiest way to create a pipe delimited file where the length of the columns should not exceed the declared size?

Example: source column is char(50) and in the target file I am declaring char(40).

In the above example DataStage is writing all 50 characters to the target as it is not a fixed width file. I know I can use substring but my source has more than 180 columns.

Appreciate your time. Please let me know if my question is not clear.

chulett · Post by **chulett** » Sun Mar 13, 2011 12:08 am

Substring.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 13, 2011 3:42 am

Study one of the productivity aids in the Transformer stage, namely Derivation Substitution.