JR30023: SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO EBCDIR DATABASE ON Z/OS WITH OBJECT NAMES IN UNICODE

DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When using Control Center to connect to a EBDCIT database on
  Z/OS with object names in Unicod 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
  EBCDIR DATABASE ON Z/OS WITH OBJECT NAMES IN UNICODE
  PROBLEM SUMMARY:
  ERROR DESCRIPTION:
  When using Control Center to connect to a EBDCIT database on
  Z/OS with object names in Unicod 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.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, FixPak 4
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  JR30022

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R950 PSY

     UP