Issue with left justified column with spaces in fixed length

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
HemaV
Participant
Posts: 63
Joined: Wed Jan 09, 2008 1:38 am
Location: Bangalore

Issue with left justified column with spaces in fixed length

Post by HemaV »

Hi Team,

I want my out put file to look like below:

Code: Select all

20 11111    xxxxxx
20 11111    yyyyy
datatype is,
col1 char(1), col2 char(2), col3 char(9),col3 char(6)

when im running my datastage job im always getting extra space after every value like below:

Code: Select all

2 0 11111     xxxxxx
for the 1st char im always getting extra space after 2.

Could you please let me know how to do left justified in transformer stage and my output is sequential file.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Isn't there a stage property for the number of spaces between columns in the output? I can't check but it sounds like it is set to 1 and it should be 0.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sriven786
Participant
Posts: 37
Joined: Wed Nov 08, 2017 1:36 pm

Re: Issue with left justified column with spaces in fixed le

Post by sriven786 »

Please provide your Output File Format

Spaces between columns: This field is only active when you select the Fixed-width columns check box. Contains a number to represent the number of spaces used between columns.
Venkata Srini
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

There is also a file format property called Delimiter string, which allows one or more characters to be specified.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply