JR30022: SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO EBCDIC DB ON Z/OS WITH OBJECT NAMES IN UNICODE

DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• When using Control Center to connect to a EBCDIC database on
  Z/OS with object names in Unicode we get SQL -104 when sending
  special characters to the host:
  
  To Reproduce:
  
  1. On the Z/OS database we have a Table which name is the
  character for the Greek letter Omega in capitals:
  
  $ cat greek2
  create table ""(c int);
  $ od -cx greek2
  0000000    c   r   e   a   t   e       t   a   b   l   e       "
              6372    6561    7465    2074    6162    6c65    2022
  cea9
  0000020    "   (   c       i   n   t   )   ;  \n
              2228    6320    696e    7429    3b0a
  0000032
  
  0xcea9 is the Character code for ?  (Omega in capitals)
  
  db2 "select hex(name) from sysibm.systables " shows
  CEA9
  
  2. From Control Center connect to the Z/Os database and
  --> right mouse key on table schema.<omega>
  --> push down menu query:
  
  select * from schema.<omega>
  
  will show in the commend editor.
  
  If we run the above query we get SQL -104.
  
  select * from schema."<omega> " using quotes on the table name
  the query runs successful
  
  Control Center is not adding "quotes" when sending the request
  to Z/OS with special characters (it works correctly in DB2 LUW).
  
  3. Using the option Open for the table gives SQL -104 and there
  is no way of changing the request by the user in command editor.
  

Local fix

• Use "" quotes to correct query in Commad Editor before sending
  to the host:
  
  select * from schema."<omega>" instead of select * from
  schema.<omega>
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO  *
  * EBCDIC DB ON Z/OS WITH OBJECT NAMES IN UNICODE               *
  * When using Control Center to connect to a EBCDIC database on *
  *                                                              *
  * Z/OS with object names in Unicode we get SQL -104 when       *
  * sending                                                      *
  * special characters to the host:                              *
  *                                                              *
  *                                                              *
  *                                                              *
  * To Reproduce:                                                *
  *                                                              *
  *                                                              *
  * 1. On the Z/OS database we have a Table which name is the    *
  *                                                              *
  * character for the Greek letter Omega in capitals:            *
  *                                                              *
  *                                                              *
  *                                                              *
  * $ cat greek2                                                 *
  *                                                              *
  * create table ""(c int);                                      *
  *                                                              *
  * $ od -cx greek2                                              *
  *                                                              *
  * 0000000    c   r   e   a   t   e       t   a   b   l   e     *
  *   "                                                          *
  *             6372    6561    7465    2074    6162    6c65     *
  * 2022cea9                                                     *
  * 0000020    "   (   c       i   n   t   )   ;                 *
  *             2228    6320    696e    7429    3b0a             *
  *                                                              *
  * 0000032                                                      *
  *                                                              *
  *                                                              *
  * 0xcea9 is the Character code for ?  (Omega in capitals)      *
  *                                                              *
  * db2 "select hex(name) from sysibm.systables " shows  CEA9    *
  *                                                              *
  *                                                              *
  * 2. From Control Center connect to the Z/Os database and      *
  *                                                              *
  * --> right mouse key on table schema.<omega>                  *
  *                                                              *
  * --> push down menu query:                                    *
  *                                                              *
  *                                                              *
  *     select * from schema.<omega>    will show in the commend *
  * editor.                                                      *
  *                                                              *
  *  If we run the above query we get SQL -104.                  *
  *                                                              *
  *                                                              *
  * select * from schema."<omega> " using quotes on the table    *
  * name  the query runs successful                              *
  *                                                              *
  *                                                              *
  *  Control Center is not adding "quotes" when sending the      *
  * request  to Z/OS with special characters (it works correctly *
  * in DB2 LUW).                                                 *
  *                                                              *
  * 3. Using the option Open for the table gives SQL -104 and    *
  * there is no way of changing the request by the user in       *
  * command editor.                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to  DB2 Version 9.1 Fixpack 9                        *
  ****************************************************************
  

Problem conclusion

• Problem was first fixed in DB2 Version 9.1 Fixpack 9
  

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:

  JR30023 IC64016

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R910 PSY

     UP