lpad in Datastage

snt_ds · Post by **snt_ds** » Sun Jun 24, 2007 11:50 am

Hi,

I have string for which I have to do the lpad.
Sql I can have lpad(ABC,18,'0').
eg :
1) 5324
000000000000005324
2) 123
000000000000000123

How can I achive the same in Datastage.

Thanks
Suresh

ray.wurlod · Post by **ray.wurlod** » Sun Jun 24, 2007 3:33 pm

There is no Lpad() function.

Use

Code: Select all

Str('0', 18 - Len(TheString)) : TheString

snt_ds · Post by **snt_ds** » Sun Jun 24, 2007 3:48 pm

Thanks Ray,

ray.wurlod · Post by **ray.wurlod** » Sun Jun 24, 2007 11:22 pm

How about you mark the topic as Resolved?

kdsuser · Post by **kdsuser** » Mon Sep 12, 2011 9:29 am

I use RIGHT instead of a LEN:

Code: Select all

Right(STR('0',18):TheString,18)

For smaller variables its cleaner looking:

Code: Select all

Right('0000':TheString,4)