Decimal data reading using sequential file stage
Posted: Fri Oct 19, 2007 10:50 pm
Hi,
We are migrating few Ab Initio graphs into Datastage jobs. We are facing some issues while reading decimal values using sequential file stage. Source and target files are ASCII plain text files. We are reading one columns as decimal(5,2). We can see actual value stored inside the source file is not having any period (.). Value stored is 12345 inside the source file without any decimal point. With decimla(10,2) datastage is reading this value as 00012345.00 whereas Abi is reading this value is 123.45 with same data type. How should I select datatype and options so as to read period properly even if it is not visible inside the source file. I know manually we can do it but I want to directly read this the way Ab Initio is reading the data.
Thanks in advance.
-Amit
We are migrating few Ab Initio graphs into Datastage jobs. We are facing some issues while reading decimal values using sequential file stage. Source and target files are ASCII plain text files. We are reading one columns as decimal(5,2). We can see actual value stored inside the source file is not having any period (.). Value stored is 12345 inside the source file without any decimal point. With decimla(10,2) datastage is reading this value as 00012345.00 whereas Abi is reading this value is 123.45 with same data type. How should I select datatype and options so as to read period properly even if it is not visible inside the source file. I know manually we can do it but I want to directly read this the way Ab Initio is reading the data.
Thanks in advance.
-Amit