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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback