DSXchange

Hi Datastage team,

i have one field contain the varchar data type(but contain integer value)

i want output value should be starts with zero then numbers.

example:

input:

2347689

output:
02347689

how can i pass the zero value in front of the integer value. or

how to convert this. please let me know.

'0':<InputColumn>

But, need to take care of the total length and the datatype of the output column to which you are going to map this.

you can use the Padstring function on your string. It enables you to define a optional pad character and lenght

DO try to think up meaningful subjects.