IBM Support

QualityStage investigation reports have inaccurate data when using the ODBC stage as output

Troubleshooting


Problem

This problem occurs only when you use "IBM DB2 Wire Protocol" ODBC driver for IBM DB2 and when you use the ODBC stage as output. The IBM InfoSphere QualityStage investigation reports for the Investigate stage are generated with inaccurate data. The qsInvCount column is incorrectly converted from the DOUBLE data type to the DECFLOAT data type.

Symptom

The reports cannot display the bar chart because the value in the Count column is 0.

Resolving The Problem

Use any of the following workarounds to generate the correct report data:

  • Use a different ODBC driver. For example, use the "IBM DB2 ODBC DRIVER".
  • In Investigate stage, change the SQL type of the qsInvCount output column to FLOAT, instead of DOUBLE.
  • In the ODBC Enterprise stage options, add the Create Statement option and insert the following command:
    CREATE TABLE "<schema-name>"."<table-name>" ( "QSINVPERCENT" DOUBLE NOT NULL , "QSINVCOLUMNNAME" VARCHAR(200) NOT NULL , "QSINVPATTERN" VARCHAR(200) NOT NULL , "QSINVCOUNT" DOUBLE NOT NULL , "QSINVSAMPLE" VARCHAR(200) NOT NULL );
    where <schema-name> is the name of database schema, and <table-name> is the name of database table. Adding this statement ensures that the qsInvCount column data type remains DOUBLE when the data is written to the database.
  • Set up the JDBC DSN in IBM WebSphere® Application Server. The DSN name must match the ODBC DSN that was setup on InfoSphere Information Server engine.

[{"Product":{"code":"SSVSBF","label":"InfoSphere QualityStage"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21399453

Page Feedback