JR35263: INFORMIX WRAPPER: RTRIM NOT PUSHDOWN

APAR status

• Closed as program error.

Error description

• DESCRIPTION:
  If you use RTRIM in queries to for Informix nicknames, the RTRIM
  can not be pushdown.
  For example, for the following query:
  SELECT * FROM informix_nickname where RTRIM(col) ='string'
  The predicate "RTRIM(col) ='string' " won't be pushdown
  
  This is because RTRIM used stands for SYSIBM.RTRIM , however
  there is no default function mapping defined in Informix wrapper
  for SYSIBM.RTRIM.
  

Local fix

• There are 2 options to workaround the problem:
  1. use SYSFUN.RTRIM instead of RTRIM
  SELECT * FROM informix_nickname where SYSFUN.RTRIM(col)
  ='string'
  
  2. create function mapping for SYSIBM.RTRIM
  For example:
  CREATE FUNCTION MAPPING MY_INFORMIX_FUN1 FOR SYSIBM.RTRIM ( CHAR
  ) SERVER TYPE INFORMIX OPTIONS (REMOTE_NAME 'RTRIM')
  SELECT * FROM informix_nickname where RTRIM(col) ='string'
  

Problem summary

• Users affected:
     Users of the Informix wrapper in the DB2 for LUW Homogeneous
  Federation Feature or InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 9.5 FixPak 6 (s100805 ). This
  fix should be applied on Federation Server.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  JR35262

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX WRAPPE

• Fixed component ID

  5724N9710

Applicable component levels

• R950 PSN

     UP