datatype problem

hargun · Post by **hargun** » Sun May 13, 2012 9:02 pm

Hi,
i have column name BAL_NAME(decimal 22,2).i have create a dummy file and give the value 345.22 while creating flat file but when in view data its showing 00000000000000000345.22 added zeros in front of values.how to get rid of zeros just want 345.22

Also for column name EFFT_DT (DATE) i enter 2011-04-03 in dummy flat file but its showing values like 40240 .Can someone helps me on this.

ray.wurlod · Post by **ray.wurlod** » Sun May 13, 2012 9:15 pm

DataStage always puts the zeroes in for Decimal data type, to prove that precision and scale are handled properly. You can only get rid of the zeroes if you use VarChar as the data type.

zulfi123786 · Post by **zulfi123786** » Sun May 13, 2012 11:29 pm

use varchar and user trim() to strip the zeros

sreewin7 · Post by **sreewin7** » Mon May 14, 2012 3:07 pm

If hope the below answer is enough for your question, if you are still struggling to get your output.

I hope your are using transformtion stage in your job, go to column right click and go to string and you can frind trim and use this.

Regards,
Sree
[quote="hargun"]Hi,
i have column name BAL_NAME(decimal 22,2).i have create a dummy file and give the value 345.22 while creating flat file but when in view data its showing 00000000000000000345.22 added zeros in front of values.how to get rid of zeros just want 345.22

Also for column name EFFT_DT (DATE) i enter 2011-04-03 in dummy flat file but its showing values like 40240 .Can someone helps me on this.[/quote]

hargun · Post by **hargun** » Mon May 14, 2012 7:52 pm

Also for column name EFFT_DT (DATE) i enter 2011-04-03 in dummy flat file but its showing values like 40240 .Can someone helps me on this.[/quote]

zulfi123786 · Post by **zulfi123786** » Tue May 15, 2012 12:09 am

hargun wrote:Also for column name EFFT_DT (DATE) i enter 2011-04-03 in dummy flat file but its showing values like 40240 .Can someone helps me on this.

[/quote]

you mean to say the seq file holds "2011-04-03" but when you do a view data you see "40240" ?

hargun · Post by **hargun** » Tue May 15, 2012 7:28 am

Hi zulfi,

Yes when i view data it shows not exactly the same date whech i enters.

zulfi123786 · Post by **zulfi123786** » Tue May 15, 2012 11:11 am

Never trust the data browsers. Create a small job to read from seq file and write to seq file and then see what's written to make sure data is not messed up

priyadarshikunal · Post by **priyadarshikunal** » Wed May 16, 2012 3:47 am

zulfi123786 wrote:use varchar and user trim() to strip the zeros

I would suggest the suppress_zero rtype in DecimalToString().

sajal.jain · Post by **sajal.jain** » Wed May 16, 2012 6:18 am

maybe 'yyyy-mm-dd' is not your default DataStage date format? Try with 'dd-mmm-yyyy'

DSXchange

datatype problem

datatype problem

Re: datatype problem