IBM Support

JR30022: SQL -104 (SQL0104N) WHEN USING CONTROL CENTER CONNECTING TO EBCDIC DB 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 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 number

    JR30022

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-28

  • Closed date

    2010-03-03

  • Last modified date

    2010-03-03

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021