scenario

Devendrudu · Post by **Devendrudu** » Thu Sep 22, 2011 2:52 am

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.

dspxlearn · Post by **dspxlearn** » Thu Sep 22, 2011 2:59 am

'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.

suse_dk · Post by **suse_dk** » Thu Sep 22, 2011 4:09 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 22, 2011 3:23 pm

DO try to think up meaningful subjects.