IBM Support

IT30460: SYNTAX ERROR -201 FOR REMOTE SQL CONTAINING DECODE/CASE EXPRESSION WITH PROJECTION/HOST VARIABLE REFERENCE

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 in inner query with function within function uses synonym
    of table from remote server as in below statement.
    
    update t01 set col15=(
            select decode(min(l2.col24), "",col15, min(l2.col24))
                    from t02 l2, t02 l1
                         where l1.col24=t01.col15 and
    l1.col22=l2.col22 and l2.col03="FIG")
    
            where col01="201905"
            and col03="SET"
            and col15 like "8*"
    
    where the "t02 l2" is a synonym to a table on remote instance.
    
    The result from this statement is "SQL Error (-201): A syntax
    error has occurred." pointing to last character of SQL.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 12.10.xC14.                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Informix Server 12.10.xC14.                        *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC14.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT30460

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-10-01

  • Closed date

    2020-02-25

  • Last modified date

    2020-02-25

  • 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

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
25 February 2020