Implied and Explicit decimal data type

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Aquilis
Participant
Posts: 204
Joined: Thu Apr 05, 2007 4:54 am
Location: Bangalore
Contact:

Implied and Explicit decimal data type

Post by Aquilis »

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
Aquilis
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Server jobs support implied decimal.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Aquilis
Participant
Posts: 204
Joined: Thu Apr 05, 2007 4:54 am
Location: Bangalore
Contact:

Post by Aquilis »

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
Aquilis
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply