IBM Support

PM95408: UNABLE TO EXECUTE A UNION ALL QUERY WITH DECIMAL TYPE USING BIG SQL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When executing a SQL UNION ALL statement which has
    columns/expressions with decimal type using BigSQL, the
    following SQL exception is returned:
    
    SQLException: SQLState=58004 SQLCode=15
    java.sql.SQLException: BIGSQL-GEN-0010 Found an internal error:
    'Failed to execute query {}.
    

Local fix

Problem summary

  • See Error Description
    

Problem conclusion

  • This problem is fixed in Version 2.1.0.1 and later fix packs.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM95408

  • Reported component name

    INFO BIGINSIGHT

  • Reported component ID

    5725C0900

  • Reported release

    210

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-19

  • Closed date

    2013-09-11

  • Last modified date

    2013-09-11

  • 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 BIGINSIGHT

  • Fixed component ID

    5725C0900

Applicable component levels

  • R210 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"210","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 August 2020