International data with DB2 z/OS - EBCDIC_STR / UNICODE_STR

Norbert Wolf

International data with DB2 z/OS - EBCDIC_STR / UNICODE_STR
Hello Jantje,

thank you for your comments! Of course you are right that only a small amount of data would need UNICODE. But - the small amount of data is in big referential chains. This means ( with DB2 V9 and V10 ), if you want to introduce UNICODE for only one column of a big tablespaceset in DB2 when you have to convert the whole tablespaceset ( in our company sometimes many hundreds of tables) to unicode. And the effect would be really big!

If you want to stay in a EBCDIC world and you only want to add some UNICODE funtionality , may be the two V9 new functions UNICODE_STR and EBCDIC_STR are helpful for that and are constructed by IBM to enrich the EBCDIC world for a small movement in the direction of UNICODE. We believe so and may be some other companies have tried them. If you try that two functions when you will recognize that you have to set DSNZPARM CMTSTAT to ACTIVE. This dependance is not documented and will be corrected by IBM in March.

may be anyone else in the DB2 world has experiences with the two V9 new functions EBCDIC_STR and UNICODE_STR?


regards

Norbert Wolf

Datev eG

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv