Problem with varchar field

arnie_nits · Post by **arnie_nits** » Mon Dec 31, 2007 2:54 am

Hi

I have got a varchar field of length 12,2. When data(say 16.25) is populated in it comes as 000000000016.25.

I want to get it as 16.25,without any zeros being padded in left. Please help.

Regards
Arnie

ray.wurlod · Post by **ray.wurlod** » Mon Dec 31, 2007 3:04 am

You have a Decimal field, not a VarChar field. (16,2) is not valid for VarChar. If, having converted this to a string there are leading zeroes, this is how DataStage does things. It displays leading (and trailing) zeroes to demonstrate that decimal precision and scale are being handled properly. Internally, of course, they are represented in a binary format.

To convert the "0" characters to " " characters or "" characters in the string the most efficient function to use is Convert().

Prabhakar · Post by **Prabhakar** » Tue Jan 01, 2008 11:42 pm

as Ray mentioned you may be decalared the coulmn as Decimal instead of decimal. so please check the scema of your job

Prabhakar · Post by **Prabhakar** » Tue Jan 01, 2008 11:43 pm

as Ray mentioned you may be decalared the coulmn as Decimal instead of Varchar. so please check the scema of your job