PM56037: DB2LOADER , DECIMAL SEPERATOR ISSUE RELATED TO THE REGIONAL SETTINGS ON WINDOWS (SQL3122W )

APAR status

• Closed as program error.

Error description

• -when loading a table with float data types from a db2 UDB
  Database in another DB2 Database with the same code page for
  example 1252 then an error is received when the regional
  settings are in German.?SQL3122W  The field value in row "F0-1"
  and column "6" cannot be            ?converted to
                                                  ?a FLOAT value,
  but the target column is not nullable.  The row was not
  ?loaded.?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos BI Server 10.2                             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

  COG8 BI DATA MG

• Fixed component ID

  5724W12DM

Applicable component levels