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

APAR status

• Closed as program error.

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:
  Loading decimal external (5,4) to table column decimal (5,4)
  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).
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP