IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR30023

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-28

  • Closed date

    2009-05-29

  • Last modified date

    2009-05-29

  • 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

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 May 2009