By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Arabic Codepage conversion problem from WIN to Z/OS

P: 2
I have DB2 v7.1.2 on IBM Z/OS
and DB2 V8.1.0.36 Level ID 01010106
Build Level s021023
with JDK 1.3.1 on my Windows platform.

I am trying to load some Arabic character data to our mainframe [Z/OS v1.4 with Unicode images loaded] DB2 tables. the EBCDID CCSID is 420. WIN CCSID is 1256.
The data originally is from SQL Server. When I load the data to my Windows DB2, everything is fine. But when I export the data from my windows DB2 to an IXF file, and then import it to my table on Z/OS, I find the Arabic character data is NOT SHAPED ( what do I mean by NOT SHAPED?
The same Arabic alphabets will take different shapes depending on its position in a word - whether it comes at the start of a word, middle or at the end of a word ). The characters in Z/OS DB2 tables are Arabic [hex values have changed from WIN to Z/OS] but not readable.

The command I used on the WIN DB2 Command LIne Processor is :
import from flatfile.ixf of ixf messages msgfile insert into tbcreator.tablename

According to IBM literature, the codepage conversion should occur; and it occurs, but not the shaping part.

My question is, am I missing something?
Or, IBM DB2 has this problem which has to be solved thru some other ways?

Any help, hints or pointers to reading material sources will be appreciated. . .
Sep 12 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.