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
Marcus426
Participant
Posts: 33 Joined: Wed Sep 09, 2009 1:37 am
Post
by Marcus426 » Fri Sep 11, 2009 3:38 pm
Hi all,
Can you guys let me know how to put a filler(all blanks) in the target sequential file(fixed length) that has to be of the size char(400). In the transformer what has to be the derivation?.
Thanks guys!
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Fri Sep 11, 2009 3:52 pm
Set padString to space and set a single blank space to that field.
ds_teg
Premium Member
Posts: 51 Joined: Tue Aug 11, 2009 6:53 am
Location: Chicago
Post
by ds_teg » Fri Sep 11, 2009 4:06 pm
Search for APT_STRING_PADCHAR
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Sep 11, 2009 4:19 pm
Or
Space(400) .
-craig
"You can never have too many knives" -- Logan Nine Fingers
Marcus426
Participant
Posts: 33 Joined: Wed Sep 09, 2009 1:37 am
Post
by Marcus426 » Fri Sep 11, 2009 4:41 pm
Thanks a lot guys!! That worked