DSXchange

Hi All,

We are migrating from Ab Initio to DataStage PX 7.5.2. We are reading from and writing into the plain text ascii files. In Ab Initio there is option known as implied and explicit decimal. I am looking for similar options in DS as that of in Abi so as to avoid complex work around and which may not work of decimal scale and precision is changed. Following are the examples:
1. Abinitio input layout :
Amount decimal(21,2) <= implied decimal
So, 1600 in a plain text source file, Abi will read as 16.00

2. Abinitio output layout :
Amount decimal(21.2) <= explicit decimal
So, 1600 from the source will be output as 16.00 in Abi

3. Abinitio input layout :
Amount decimal(23,4) <= implied decimal
So, 160000 in a plain text source file will be read as 16.0000

4. Abinitio output layout :
Amount decimal(23.4) <= explicit decimal
So, it should be output as 16.0000

For example-1, in DS if we mention datatype as decimal(21,2), it will read the data as 1600. And if in the target we have same datatype it will be stored as 1600. However, I need a option to read this value as 16.00 and store as 16.00 without any division by 100 or so.

Thanks in advance.
-Aquilis

Server jobs support implied decimal.

Hi Ray,

Thanks for your reply. You mean then there is no way to handle such datatype in PX. Everyting we need to do manually? Any reason why it's there in server but not in PX.

Thanks,
Aquilis

The simple answer is that there are no data types in server jobs (internally), but parallel jobs executed in a strongly-typed C-language environment.