Dealing with Numeric value in Datastage.

srinath51 · Post by **srinath51** » Mon Mar 05, 2012 8:36 am

Hi All,

i have a field named - "ITEM_SEQ_R" Num(5,0),the values for the field in the Sql database are 622,355.
when i use the above field and generate a text file then i get output as
' 00622.',But i want the output as '000622.'

when i concatenate a '0' then i get '0 00622.',So my question is How can i get this value in Datastage -- '000622.' instead of ' 00622.'

pandeesh · Post by **pandeesh** » Mon Mar 05, 2012 9:12 am

What , if you change that to Num(6,0)?

jwiles · Post by **jwiles** » Mon Mar 05, 2012 9:24 am

Define your field as 6 digits in length instead of 5.

The space you're seeing is reserved for the sign in a decimal (Number field) which has been converted to character...you can always Trim() it before concatenating (unless it's '-' then you'll need to use left(), right() and/or substrings).

Regards,

srinath51 · Post by **srinath51** » Mon Mar 05, 2012 10:00 am

Thanks Pandeesh & Jwiles...

i converted and now it works fines as i desired.

pandeesh · Post by **pandeesh** » Mon Mar 05, 2012 10:39 am

So, can you please resolve the topic?