FMT function in parallel transfer

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
pongal
Participant
Posts: 77
Joined: Thu Mar 04, 2004 4:46 am

FMT function in parallel transfer

Post by pongal »

Hi,
i wanted the exact parallel function to format a value.
eg:- i need to generate a 6 digit number like
FMT(@OUTROWNUM,"6''0'R")
"000001"
"000002"

FMT does not work on parallel transformer and i should not use Basic transformer here for this formatting.

is there any parallel function which takes care padding zero's on the left side of the value?
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Right(PadString("","0", length) : Trim(YourValue), length)
Post Reply