JR32626: SETUNSCALED METHODS DON'T SUPPORT DATATYPE CONVERSIONS

APAR status

• Closed as program error.

Error description

• If the Teradata Connector selects a DECIMAL column but it's
  defined as Integer on the Columns tab, the job fails with this
  error:
  
  [IIS-CONN-DAAPI-000045] Can not convert to framework type int32
  (CC_PXAccessor::setUnscaledShort, file CC_PXAccessor.cpp, line
  4,995) [pxbridge.C:2945]
  
  The problem is that the Teradata Connector describes the column
  as DECIMAL, but the connector framework's schema reconciliation
  changes the data type to Integer.  Most of the set methods in
  CC_PXAccessor will do the conversion if the PX data type does
  not correspond to the method used, but the setUnscaled methods
  don't support the conversion.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Teradata connector users
  ****************************************************************
  PROBLEM DESCRIPTION:
  If the Teradata Connector selects a DECIMAL column but it's
  defined as Integer on the Columns tab, the job fails with this
  error:
  
  [IIS-CONN-DAAPI-000045] Can not convert to framework type int32
  (CC_PXAccessor::setUnscaledShort, file CC_PXAccessor.cpp, line
  4,995) [pxbridge.C:2945]
  
  The problem is that the Teradata Connector describes the column
  as DECIMAL, but the connector framework's schema reconciliation
  changes the data type to Integer.  Most of the set methods in
  CC_PXAccessor will do the conversion if the PX data type does
  not correspond to the method used, but the setUnscaled methods
  don't support the conversion.
  ****************************************************************
  RECOMMENDATION:
  Apply the patch for JR32626
  ****************************************************************
  

Problem conclusion

• Added conversion code to setUnscaledInteger family of functions
  so that they can work with integer fields.
  

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:

Modules/Macros

• CC FMWK
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP