JR45161: Informix-EE read stage adds extra spaces for varchar column.

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• When reading from informix database extra spaces are added to
  the original data, only when
  data exists is less than the defined length in the database.
  
  create table char_test (col1 varchar(20),col2 varchar(20));
  insert into char_test values('aaaaaaaaaa','aaaaa');
  insert into char_test values('bbbbb','bbbbb');
  insert into char_test values('ccccc','cccccccccc');
  insert into char_test values('ddddddddddd','ddddddddddd');
  
  After running the job the output is:
  'aaaaaaaaaa          ','aaaaa                    '
  'bbbbb               ','bbbbb                    '
  'ccccc               ','cccccccccc               '
  'dddddddddd          ','dddddddddd               '
  

Local fix

Problem summary

• Informix-EE read stage adds extra spaces for varchar column.
  

Problem conclusion

• Fixed: Added new environment variable APT_INFX_PAD_VARCHAR to
  get correct varchar data.
  
  Note: set APT_INFX_PAD_VARCHAR environment variable to 1
  

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

• INFXEE
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R870 PSY

     UP