DB2 tables store Chinese character data as Unicode ccsid. Is this supported by CA Easytrieve?
search cancel

DB2 tables store Chinese character data as Unicode ccsid. Is this supported by CA Easytrieve?

book

Article ID: 54041

calendar_today

Updated On:

Products

PanAudit Plus Easytrieve Report Generator PAN/SQL Endevor Endevor Natural Integration Endevor - ECLIPSE Plugin Endevor - Enterprise Workbench

Issue/Introduction

Description:

The CA Easytreive product does not support UNICODE data type at present.

Solution:

Please see:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.apsg/qchp9.htm.

The DB2 NEWFUN(YES) means that the SQL statements in the DBRM use Unicode UTF-8.

CCSID conversion of source programs: If the SQL statements of your source program are not in Unicode UTF-8, the DB2 Version 8 precompiler converts then to UTF-8 for parsing. The precompiler uses the source CCSID value to convert from that CCSID to CCSID 1208 (UTF-8). If you want to prepare a source program that is written in a CCSID that cannot be directly converted to or from CCSID 1208, you must create an indirected conversion. (For information about indirect conversions, see z/OS Support for Unicode).

Since CA Easytrieve does not support Unicode, CA Easytrieve cannot handle the data.

Environment

Release: EDBMSU00200-6.4-Easytrieve-Report Generator-Option for DB2-MSU
Component: