I need to add zeros to the left of two fields... lets take ckd_amt and ck_nbr fields.
if it was sql then LPAD is an option.. likewise is there an option in progress ?
The total content length after lpading should be 10 for both....
I tried declaring a variable as integer '9999999999' and then adding the variable to ck_nbr.. but it was displaying properly in the procedure editor but when i tried the same in a stream ..its not working...
Any idea ? and for ckd_amt I still dont have a clue.
Thanks for any help.
if it was sql then LPAD is an option.. likewise is there an option in progress ?
The total content length after lpading should be 10 for both....
I tried declaring a variable as integer '9999999999' and then adding the variable to ck_nbr.. but it was displaying properly in the procedure editor but when i tried the same in a stream ..its not working...
Any idea ? and for ckd_amt I still dont have a clue.
Thanks for any help.