Numeric (P, S)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Numeric (P, S)
Hi,
I've a monetary field defined as Numeric (30, 6). Data contained in table while readin by DS gets truncated to 14/15th digits.
<table>
<tr>
<td>File Value <td>Read/Written Value
<tr>
<td>==================== <td>====================
<tr><td>2345678910111213.999999 <td>2345678910111210
<tr><td>23456767767768768768 <td>23456767767768800000
<tr><td>23435743579403759075043 <td>23435743579403800000000
</table>
Any solution to this.[quote][/quote]
I've a monetary field defined as Numeric (30, 6). Data contained in table while readin by DS gets truncated to 14/15th digits.
<table>
<tr>
<td>File Value <td>Read/Written Value
<tr>
<td>==================== <td>====================
<tr><td>2345678910111213.999999 <td>2345678910111210
<tr><td>23456767767768768768 <td>23456767767768800000
<tr><td>23435743579403759075043 <td>23435743579403800000000
</table>
Any solution to this.[quote][/quote]
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Re: Numeric (P, S)
Need to send this numeric field for aggregation (Sum). Cannot use other data types like char fields.
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Thankx friend very much for the suggestion.
EXACTNUMERIC was set to 38 immediately after the installation as suggested by my friends.
Is there any limitation which is causing the problem.
FYI.
smat -d shows EXACTNUMERIC as 38.
Still the problem persists. DS 7.5 in installed on Win XP. I have searched all DS forums, but couldn't find any satisfactory answer and cause.
Pls advice ?
EXACTNUMERIC was set to 38 immediately after the installation as suggested by my friends.
Is there any limitation which is causing the problem.
FYI.
smat -d shows EXACTNUMERIC as 38.
Still the problem persists. DS 7.5 in installed on Win XP. I have searched all DS forums, but couldn't find any satisfactory answer and cause.
Pls advice ?
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
Let me understand. You have EXACTNUMERIC set to 38 in your uvconfig, the database table definition for a column is (30,6), you define the column as (30,6) in your database read stage (which stage, which database?) and when you output this column to a sequential file keeping the same (30,6) definition it rounds the number to an integer?
Ignore the aggregator for the moment. If this is the case, you have a reproduceable test case to submit to your support provider. If the above doesn't reproduce the problem, then the error must lie elsewhere.
Ignore the aggregator for the moment. If this is the case, you have a reproduceable test case to submit to your support provider. If the above doesn't reproduce the problem, then the error must lie elsewhere.
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
Yes, I keep this post alive.
DS 7.5 is now a thing of past for me. Theres no more issue with DS 8 about handling of big numbers.
Most of the products were never tested for such huge numbers, I reckon.
1. DS 7.5 had problem. Vanished with DS 8.
2. Informatica 7.1 PowerCenter too had the same problem.
3. Ab Initio - No idea, as such huge numbers were never dealt with.
Kind regards,
Abhijit
DS 7.5 is now a thing of past for me. Theres no more issue with DS 8 about handling of big numbers.
Most of the products were never tested for such huge numbers, I reckon.
1. DS 7.5 had problem. Vanished with DS 8.
2. Informatica 7.1 PowerCenter too had the same problem.
3. Ab Initio - No idea, as such huge numbers were never dealt with.
Kind regards,
Abhijit
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
---
Yes, I keep this post alive.
DS 7.5 is now a thing of past for me. Theres no more issue with DS 8 about handling of big numbers.
Most of the products were never tested for such huge numbers, I reckon.
1. DS 7.5 had problem. Vanished with DS 8.
2. Informatica 7.1 PowerCenter too had the same problem.
3. Ab Initio - No idea, as such huge numbers were never dealt with.
Kind regards,
Abhijit
DS 7.5 is now a thing of past for me. Theres no more issue with DS 8 about handling of big numbers.
Most of the products were never tested for such huge numbers, I reckon.
1. DS 7.5 had problem. Vanished with DS 8.
2. Informatica 7.1 PowerCenter too had the same problem.
3. Ab Initio - No idea, as such huge numbers were never dealt with.
Kind regards,
Abhijit
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
-
- Participant
- Posts: 81
- Joined: Tue Aug 15, 2006 8:31 am
- Location: Zürich
- Contact:
---
Yes, I keep this post alive.
DS 7.5 is now a thing of past for me. Theres no more issue with DS about handling of big numbers as we are onto DS8.
Most of the products were never tested for such huge numbers, I reckon.
1. DS 7.5 had problem. Vanished with DS 8.
2. Informatica 7.1 PowerCenter too had the same problem.
3. Ab Initio - No idea, as such huge numbers were never dealt with.
Kind regards,
Abhijit
DS 7.5 is now a thing of past for me. Theres no more issue with DS about handling of big numbers as we are onto DS8.
Most of the products were never tested for such huge numbers, I reckon.
1. DS 7.5 had problem. Vanished with DS 8.
2. Informatica 7.1 PowerCenter too had the same problem.
3. Ab Initio - No idea, as such huge numbers were never dealt with.
Kind regards,
Abhijit
Kind regards
Abhijit Gaikwad
Abhijit Gaikwad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The "problem" in DataStage server edition is not one of EXACTNUMERIC but one of PRECISION. The maximum PRECISION setting is 14 significant digits. I guess that stems from the fact that the technology was invented in the mid 1960s, when numbers that large simply did not occur in commercial data processing (8-bit or 16-bit operating systems and all that).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.