IC91308: REPORT OF ISQL RETURNS WRONG RESULTS WITH MULTI-BYTE CHARACTERS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • The REPORT functionality of ISQL returns wrong results.  The
    conditions are below.
    
    - locales are set to ja_jp.sjis-s or ja_jp.sjis.
    - stty of terminals are set:
      kill = @, -echok -echoke
    - matches/like condition with:
      *NNN*, the last N is multi-byte character and consist of
    0xXX40.
    
    When  the report displays the prompt like 'Enter name =' and
    *NNN* mentioned above is entered,
    all of the characters except the last '*' is killed (removed)
    and only '*' is sent as the matches
    condition to the server then the server returns all of the data
    because of '*' condition.
    It demonstrates that the REPORT function does not treat the
    character @ that is 0x40 well. The Query function
    of ISQL or Dbaccess can return the correct result if the same
    condition is specified in a query.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all ISQL users                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to 7.50.xC7 or patched version of ISQL        *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC91308

  • Reported component name

    IBM INFORMIX SQ

  • Reported component ID

    5724C5500

  • Reported release

    732

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-03

  • Closed date

    2014-05-08

  • Last modified date

    2014-05-08

  • 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

  • R730 PSN

       UP

  • R730 PSY

       UP

  • R731 PSN

       UP

  • R731 PSY

       UP

  • R732 PSN

       UP

  • R732 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Tools
Informix SQL (I-SQL)

Software version:

732

Reference #:

IC91308

Modified date:

2014-05-08

Translate my page

Machine Translation

Content navigation