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.table name
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. . .
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.table name
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. . .