Filler in the target using transformer

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
Marcus426
Participant
Posts: 33
Joined: Wed Sep 09, 2009 1:37 am

Filler in the target using transformer

Post by Marcus426 »

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!
Top
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Set padString to space and set a single blank space to that field.
Top
ds_teg
Premium Member
Premium Member
Posts: 51
Joined: Tue Aug 11, 2009 6:53 am
Location: Chicago

Post by ds_teg »

Search for APT_STRING_PADCHAR
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or Space(400). :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Marcus426
Participant
Posts: 33
Joined: Wed Sep 09, 2009 1:37 am

Post by Marcus426 »

Thanks a lot guys!! That worked
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”