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
Append Leading Zeros
Moderators: chulett, rschirm, roy
Re: Append Leading Zeros
Use the Str function for the derivation of the output column as -
Str("0", 8 - Len(inputcolumn)) : inputcolumn
Str("0", 8 - Len(inputcolumn)) : inputcolumn