DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Aquilis
Participant



Joined: 05 Apr 2007
Posts: 201
Location: Bangalore
Points: 2275

Post Posted: Sat Oct 27, 2007 8:53 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 52036
Location: Sydney, Australia
Points: 282486

Post Posted: Sat Oct 27, 2007 10:52 pm Reply with quote    Back to top    

Server jobs support implied decimal.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Aquilis
Participant



Joined: 05 Apr 2007
Posts: 201
Location: Bangalore
Points: 2275

Post Posted: Sun Oct 28, 2007 2:23 pm Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 52036
Location: Sydney, Australia
Points: 282486

Post Posted: Sun Oct 28, 2007 10:50 pm Reply with quote    Back to top    

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.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours