JR56278: ODBC CONNECTOR IN SERVER CANVAS, UNEXPECTED THOUSAND SEPARATOR

Download Data Integration Rollup 1 for InfoSphere Information Server 11.5.0.1

APAR status

• Closed as program error.

Error description

• ODBC Connector reading numeric datatype from GreenPlum database
  on Server Canvas adds unwanted thousand separator , (comma).
  
  Extracting NUMERIC data from Greenplum using a server job such
  as ODBC Connector --> Sequential File, unexpected thousand
  separator appeared in target file.
  For example, extracting
  1000
  999
  1000000
  stored in NUMERIC(15,3) column, it became
  1,000
  999.000
  1,000,000
  in the target sequential file.
  

Local fix

• In Columns tab in ODBC Connector stage, change NUMEIRC type to
  DECIMAL type.
  

Problem summary

• ODBC Connector in Server canvas, unexpected thousand separator
  

Problem conclusion

• Corrected the behavior to show correct values.
  

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

• ODBC-CC
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSY

     UP