JR37574: ODBC CONNECTOR JOBS FAILING WITH ERROR "INVALID CHARACTER VALUE.ERROR IN PARAMETER 1." WHEN THE DECIMAL FIELD IS USED AS KEY COL

APAR status

• Closed as program error.

Error description

• While connecting to the Oracle database using the ODBC
  Connector, when there is a numeric field defined as not null,
  then the job is aborting with this error message.
  
  ODBC function "SQLExecute" reported:  SQLSTATE = 22018: Native
  Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire
  Protocol driver]Invalid character value. Error in parameter 1.
  (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp,
  line 604)
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using ODBC Connector and Connecting to Oracle Database.
  ****************************************************************
  PROBLEM DESCRIPTION:
  ODBC CONNECTOR JOBS FAILING WITH ERROR "INVALID CHARACTER
  VALUE.
  ERROR IN PARAMETER 1.
  
  While connecting to the Oracle database using the ODBC
  Connector, when there
  is a numeric field defined as not null, then the job is
  aborting with this error message.
  ODBC function "SQLExecute" reported: SQLSTATE = 22018: Native
  
  Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire
  Protocol driver]
  nvalid character value.
  Error in parameter 1.(CC_OdbcDBStatement::executeInsert, file
  CC_OdbcDBStatement.cpp,l
  ine 604)
  ****************************************************************
  RECOMMENDATION:
  Apply the APAR 37574
  ****************************************************************
  

Problem conclusion

• Corrected the binding.
  

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 PSN

     UP