JR34527: Server job Column defined as CHAR(1) in a Lookup Oracle table contains an invalid character on output

IBM InfoSphere Information Server, Version 8.7 Fix Pack 1
IBM InfoSphere Information Server, Version 8.5 Fix Pack 3

APAR status

• Closed as program error.

Error description

• In a CHAR(1) column queried by ORAOCI plugin in lookup context,
  extra charactersare added to the output field.
  

Local fix

• Change the definition of data: CHAR(1) to VARCHAR(1)
  
  This fix is included in 8.0.1 fixpack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  COMPONENT  : Oracle OCI Plugin
  LAYERS   : Engine
  OPERATING SYSTEM : AIX
  VERSION   : 8.0.1.0  8.0.1.1  8.0.1.2
  ****************************************************************
  PROBLEM DESCRIPTION:
   When fetching from a CHAR(1) datatype with the Oracle OCI stage
  in lookup context, extra characters were appearing on output.
  The incorrect length was being used  the extract the value
  fetched from Oracle.
  ****************************************************************
  RECOMMENDATION:
  Install patch  patch_JR34527_server_aix_8010-2 .
  ****************************************************************
  

Problem conclusion

• Code was fixed to use the correct length in Lookup context.
  

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

• ENGINE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R801 PSN

     UP