IBM Support

IT42685: WHEN EXECUTING A SQL SERVER STORED PROCEDURE THE 'OUTPUT' KEYWORD IS CORRUPTED SO THAT 'OUTPUT' BECOMES 'OUTPUTOUTPUT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as change to accomodate OEM Vendor's code.

Error description

  • When executing an SQL Server stored procedure the 'OUTPUT'
keyword is being corrupted leading to the following error.
SQL State 'HY000'; Native Error Code '102'; Error Text
'[IBM][ODBC SQL Server Wire Protocol driver][Microsoft SQL
Server]Incorrect syntax near 'OUTPUTOUTPUT'

Local fix

  • 



Problem summary


    

  • ****************************************************************
USERS AFFECTED:
All Users off IBM Integration Bus and App Connect Enterprise on
Linux or Unix platforms who use SQL Server database stored
procedures.


Platforms affected:
AIX, HP-UX Itanium platform, Linux on Power platform, Linux on
x86-64 platform, Linux on zSeries platform, Solaris x86-64
platform, Solaris SPARC platform

****************************************************************
PROBLEM DESCRIPTION:
When executing an SQL Server stored procedure the 'OUTPUT'
keyword is being corrupted leading to the following error.
SQL State 'HY000'; Native Error Code '102'; Error Text
'[IBM][ODBC SQL Server Wire Protocol driver][Microsoft SQL
Server]Incorrect syntax near 'OUTPUTOUTPUT'

    



Problem conclusion


    

  • An updated SQL Server ODBC driver that corrects the issue is now
supplied.

---------------------------------------------------------------
The fix is targeted for delivery in the following PTFs:

Version    Maintenance Level
v10.0      10.0.0.26
v10.1      10.1.0.1
v11.0      11.0.0.20
v12.0      12.0.8.0

The latest available maintenance can be obtained from:
http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041

If the maintenance level is not yet available,information on
its planned availability can be found on:
http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
---------------------------------------------------------------

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    IT42685
    • 

  • Reported component name
    INTEGRATION BUS
    • 

  • Reported component ID
    5724J0540
    • 

  • Reported release
    A00
    • 

  • Status
    CLOSED  OEM
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-12-12
    • 

  • Closed date
    2023-08-02
    • 

  • Last modified date
    2023-08-16
    • 





    

  • 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":"BU029","label":"Software"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.0"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            16 August 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback