IBM Support

JR53274: STP DB2 WRITES SINGLE ROW WHEN PROCEDURE RETURNS ZERO ROWS

Fixes are available

InfoSphere Information Server, Version 11.5 for Linux
InfoSphere Information Server, Version 11.5.0.1 for Windows
InfoSphere Information Server, Version 11.5.0.2 for Linux
InfoSphere Information Server, Version 11.5.0.2 for AIX
InfoSphere Information Server, Version 11.5.0.2 for Windows
InfoSphere Information Server, Version 11.5.0.1 for AIX

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Stored procedure stage in source context connecting to DB2
writes a null row to output when the stored procedure returned
0 rows and "Procedure Status to Link" is not selected.

Local fix

  • n/a

Problem summary

  • Stored procedure stage in source context connecting to DB2
writes a null row to output when the stored procedure returned 0
rows and "Procedure Status to Link" is not selected.

Problem conclusion

  • Made code changes to write output row only when data is returned
from the procedure.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR53274
    • 

  • Reported component name
    INFO SRVR PLATF
    • 

  • Reported component ID
    5724Q3612
    • 

  • Reported release
    B30
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2015-05-05
    • 

  • Closed date
    2015-06-15
    • 

  • Last modified date
    2015-06-15
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    INFO SRVR PLATF
    • 

  • Fixed component ID
    5724Q3612
    • 



Applicable component levels


    

  • R910  PSY
       UP
    • 

  • R912  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.3","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            07 January 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback