# JR33418: LOADING DECIMAL EXTERNAL (5,4) TO TABLE COLUMN DECIMAL (5,4) APPEARS TO PUT DECIMAL POINT IN WRONG LOCATION.

## Subscribe

You can track all active APARs for this component.

## Error description

• ```While data is being loaded, internally data is stored as 2 parts
. The number part and a scale associated with the number.

Below table shows the Data and the corresponding number and
scale attached to it.

Data                 Number       Scale
1.0000               1                 4
0.92                   92               2
1.0                     1                 1
0.678                678              3

While loading we can specify scale in the TMU control file as
well. But this scale comes into effect only when the data is not
in decimal format. In case the data is in decimal format the
scale is taken based on the decimal point in the data. Let me
explain this with an example.

When we specify something like this external (5,4) in the TMU
control file , 4 is the scale here. But this scale is applicable
only when the data is not in decimal format.

So if you consider 0.92 as the data and external (5,4) is
present in the control file, data is internally stored as number
= 92 and scale = 2 . And NOT as number = 92 and scale = 4.

I think this is the point which is causing all the confusion
here.

So in our case when data is 1  and external (5,4) is defined in
the control file internally it is stored as number = 1 and scale
= 4 ( Note here that scale is 4 because 1 is not decimal data) .
So this translates to 0.0001.

So either only external(5) should be present in the TMU control
file generated by Data Stage without any scale because the data
is not in decimal format.

OR

The data should be in decimal format in case the scale is
present so that the scale is taken from the data itself and not
from the external(5,4) clause.
```

## Local fix

• ```This fix is included in 8.0.1 fixpack 3
```

## Problem summary

• ```****************************************************************
USERS AFFECTED:
Information Server 801_fp2, RedBrick plugin
****************************************************************
PROBLEM DESCRIPTION:
appears to put decimal point in wrong location.
****************************************************************
RECOMMENDATION:
Install the patch.
patch_JR33418_server_redhat_801fp1.tar
****************************************************************
```

## Problem conclusion

• ```Fixed,
Inside the control file for decimal datatypes,
It creates decimal external(5) instead of decimal
external(5,4).
```

## APAR Information

JR33418

• ### Reported component name

WIS DATASTAGE

5724Q36DS

801

CLOSED PER

NoPE

NoHIPER

NoSpecatt

2009-06-19

2009-07-02

2010-12-09

## Fix information

• ### Fixed component name

WIS DATASTAGE

5724Q36DS

## Applicable component levels

• ### R801 PSN

UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Modified date:
09 December 2010