string to decimal

[Abhijeet]

Hi ,

what would be the expected output if i try to read a string say "1024" using datatype decimal[4,2] in a sequential file ?

also what will be the output if the string is 10.

Please reply , I dont have an environment to check these things.

Thanks

[ajmore]

Hi ,

what would be the expected output if i try to read a string say "1024" using datatype decimal[4,2] in a sequential file ?

also what will be the output if the string is 10.

Please reply , I dont have an environment to check these things.

Thanks

Hi Abhi...
The Expected output is 1024.00 using Datatype decimal[4,2] and for 10 it is 10.00 ....
can anyone specify why it may be so....

[jayantthakore]

HI Abhi,

Decimal[4,2] will give output 1024.00.
But String 10 will only give '1024' if its a VarChar or '1024 ' if its a Char.

[Mike]

Decimal[4,2] is a 3-byte packed decimal. I would expect that you should get an error if you try to read strings like "1024" and "10" as if they were packed decimal. I think you will need to read them in as strings and then convert them to decimal.

Mike

[kumar_s]

Decimal(4,2) ment total length is 4 and out of it, precision is 2. And hence the mantissa is also 2 here. If it is fixed width 4 consicutive digit can be read as 4,2.
In case of delimited input, 10 will be considired as 10.00.

[ray.wurlod]

It is always safest to treat text files as if they contain text as the only data type. Within the DataStage job you can then apply data type conversion functions using a Modify stage or a Transformer stage. The obvious exception is when you know that there are binary data in the "text" file.