JR50579: Teradata Connector is fetching data with a different precision when there is mismatch in the scale part of Decimal datatype

APAR status

• Closed as program error.

Error description

• Teradata Connector fetches the data with a different precision
  when there is mismatch between the table definition and stage
  definition for the scale part of a Decimal datatype.
                                                                 .
  For example in the database  the data is stored as
  DECIMAL(18,3), with stored values such as:  2.000
  If the Teradata Connector selects this data into a column
  defined as Decimal(30,5), then the result in job is incorrectly:
  0000000000000000000000000.02000
  

Local fix

Problem summary

• Teradata Connector is fetching data with a different precision
  when there is mismatch in the scale part of Decimal datatype
  

Problem conclusion

• Corrected the code to give the correct precision when the design
   schema is different to the external schema
  

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

• R850 PSY

     UP