DSXchange

Hi ,


From source(teradata) I am extracting a decimal coln with datatype decimal(6) and putting it in to a text file with datatype(decimal(6)).My problem is ,for source value 500 i am getting output as [b]000500.[/b] (with the period). I dont know how to supress this zero and period. :( . if any body know how to resolve it.

Search for decimalToString

Supressed Zero as u said . But my target is Decimal. while inserting again i convert it in to string to decimal. still it is showing the same result.

Does it matters if you are writing varchar(6) or Integer to the sequential file instead of decimal(6)?

Yes. Our client need it in that format :(

Is it fixed width or delimited output?

Delimited with ,

Then call it Varchar(6)

In client side they are loading it in to some other database.There it is like decimal (6). will it wont give problem if it varchar in file.

I dont think it will make any difference since your source is a decimal .Also , there is an option called supress zero in the conversion function you can try with it and let us know if its working or not

I used That supress Zero option . It is working fine if the target is varchar.But my target coln is decimal(6)

Why don't you give it a try by making your output as Varchar(6) ?

The decimal field will always have zero padded in front of the actual value to make it to defined length. You can't do anything with that. Changing it to VarChar(6) will not impact the other jobs reading this field as decimal(6) as the sequential file doesn't store the metadata and the value present in that field id numeric.

Exactly. You are trying to 'solve' a non-existent problem.

Thanks a lot every body