Append Leading Zeros

[pavan_test]

Hi all,

The output column length has to be 8 bytes. If the data in the incoming column (say xyz) is less than 8 bytes then I have to append leading zeros (to make to equal to 8 bytes) before writing the output file.

can someone please let me know how can achieve this in datastage.

Thanks
pavan

[chulett]

You need to emulate an lpad and ensure your target is a string.

[rprajput]

Use the Str function for the derivation of the output column as -

Str("0", 8 - Len(inputcolumn)) : inputcolumn

[jwiles]

Or even simpler and generally less expensive (assuming your input is either string or integer):

right("00000000" : inputcolumn,8)

Regards,

[chulett]

Both of which are in the post I linked to.