IBM Support

PH25330: 'ETI714E - SQL ERROR: CHARACTER CONVERSION BETWEEN CCSID 1200 TO65534' OCCURS DURING OPENING A TBL W/GRAPHIC OR VARGRAPHIC COLS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Before applying this fix, the "ETI714E - SQL ERROR: CHARACTER
    CONVERSION BETWEEN CCSID 1200 TO 65534 REQUESTED BY DSNXROHB IS
    NOT SUPPORTED" error occurred when Db2 Table Editor tried to
    open a table with GRAPHIC or VARGRAPHIC columns with UNICODE
    data.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM Db2 Table Editor for z/OS       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Error occurred when Db2 Table Editor    *
    *                      tried to open a table with GRAPHIC,     *
    *                      VARGRAPHIC or LONG VARGRAPHIC columns   *
    *                      with UNICODE data.                      *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    The "ETI714E - SQL ERROR: CHARACTER CONVERSION BETWEEN CCSID
    1200 TO 65534 REQUESTED BY DSNXROHB IS NOT SUPPORTED" error
    occurred when Db2 Table Editor tried to open a table with
    GRAPHIC, VARGRAPHIC, or LONG VARGRAPHIC columns with UNICODE
    data. Rows with these data types are not displayed.
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH25330

  • Reported component name

    DB2 TABLE EDITO

  • Reported component ID

    5697G6500

  • Reported release

    150

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-05-12

  • Closed date

    2020-06-10

  • Last modified date

    2020-07-06

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

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

    UI69957

Modules/Macros

  • ETI2PSEL
    

Fix information

  • Fixed component name

    DB2 TABLE EDITO

  • Fixed component ID

    5697G6500

Applicable component levels

  • R150 PSY UI69957

       UP20/06/12 P F006

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.5.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021