IBM Support

JR34296: DATA IS PADDED WHEN PLACING NEW MESSAGES ON THE QUEUE WITH THE MQ CONNECTOR STAGE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • In the DataStage job, the column(s) defined have VARCHAR
    datatype with a length defined. When a message is written to the
    queue, the data will be padded (left justified) with whatever
    the current padding character is defined to be. The default
    padding character is the ascii null byte 0x00, but this can be
    changed with the APT_STRING_PADCHAR environment variable.  This
    behavior is incorrect for VARCHAR columns.  Only fixed
    length CHAR columns should be padded.
    

Local fix

  • There is a workaround in some situations.  If it is acceptable
    within the job design to remove the length specification from
    the VARCHAR column, this will solve the issue and the data will
    no longer be padded.
    
    This fix is included in 8.0.1 fix pack 3
    

Problem summary

Problem conclusion

Temporary fix

Comments

  • This requirement has been implemented in 8.1
    

APAR Information

  • APAR number

    JR34296

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED SUG

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-16

  • Closed date

    2009-10-09

  • Last modified date

    2010-12-09

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
09 December 2010