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

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