DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
HemaV
Participant



Joined: 09 Jan 2008
Posts: 63
Location: Bangalore
Points: 670

Post Posted: Mon Dec 18, 2017 3:38 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
Hi Team,

I want my out put file to look like below:

Code:
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:
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

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42622
Location: Denver, CO
Points: 219444

Post Posted: Mon Dec 18, 2017 8:12 am Reply with quote    Back to top    

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

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
sriven786
Participant



Joined: 08 Nov 2017
Posts: 35

Points: 260

Post Posted: Mon Dec 18, 2017 1:27 pm Reply with quote    Back to top    

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
Rate this response:  
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2790
Location: USA
Points: 21042

Post Posted: Tue Dec 19, 2017 7:53 am Reply with quote    Back to top    

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
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours