IBM Support

IT11646: SQL PARSING ERROR WHEN USING LIKE OPERATOR IN WHERE CLAUSE WITH DATADIRECT SQL SERVER WP DRIVER

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • When using the DataDirect SQL Server Wire Protocol ODBC Driver
    UKsqls**.so to perform an SQL operation with a WHERE clause that
    contains a LIKE operation, the following error might be seen:
    
    BIP2322E: Database error: SQL State ''HY000''; Native Error
    Code '0';
    Error Text ''[unixODBC][IBM][ODBC SQL Server Wire Protocol
    driver]Error encountered during the SQL Parsing.''.
    

Local fix

  • <html>None
    </html>
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    All users of IBM Integration Bus v9.0 and v10.0 using the
    DataDirect SQL Server Wire Protocol ODBC V7 driver.
    
    
    Platforms affected:
    AIX, HP-UX Itanium platform, Linux on Power platform, Linux on
    x86 platform, Linux on x86-64 platform, Linux on zSeries
    platform, Solaris x86-64 platform, Solaris SPARC platform
    
    ****************************************************************
    PROBLEM DESCRIPTION:
    When using the DataDirect SQL Server Wire Protocol ODBC driver
    UKsqls**.so to perform an SQL operation with a WHERE clause that
    contains a LIKE operation, the following error might be seen:
    
    BIP2322E: Database error: SQL State ''HY000''; Native Error Code
    '0';
    Error Text ''[unixODBC][IBM][ODBC SQL Server Wire Protocol
    driver]Error encountered during the SQL Parsing.''.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT11646

  • Reported component name

    INTEGRATION BUS

  • Reported component ID

    5724J0530

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-10-08

  • Closed date

    2016-03-07

  • Last modified date

    2016-07-18

  • 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

    INTEGRATION BUS

  • Fixed component ID

    5724J0530

Applicable component levels

  • R900 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNQK6","label":"IBM Integration Bus"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
23 March 2020