Delimited file with fixed width
Posted: 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.
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.