JR45243: JDBC ADAPTER 7.5 INBOUND FAILING AS '!=' OPERATION IS NOT SUPPORTED BY TERADATA DATABASE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Problem:
    --------
    
    JDBC Adapter 7.5 does fail on inbound (event) processing as '!='
    operation is not supported by TERADATA database.
    
    Teradata database does only use '<>' for 'not equal' comparision
    operator in its SQL implementation, and does not support '!='
    which is used by JDBC Adapter.
    

Local fix

  • n/a
    

Problem summary

  • SQLException during execution of SQL query for unsupported (!=)
    operator
    

Problem conclusion

  • Modify the query to follow SQL standrd not equal(<>) operator.
    Adapter IFix 7.5.0.1IF03 is released for the same
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45243

  • Reported component name

    WEBS ADPT JDBC

  • Reported component ID

    5724L7700

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-21

  • Closed date

    2013-01-25

  • Last modified date

    2013-01-30

  • 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

    WEBS ADPT JDBC

  • Fixed component ID

    5724L7700

Applicable component levels

  • R750 PSY

       UP



Document information


More support for:

WebSphere Adapters Family
Adapter for JDBC

Software version:

7.0

Reference #:

JR45243

Modified date:

2013-01-30

Translate my page

Content navigation