473,948 Members | 11,806 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Arabic Codepage conversion problem from WIN to Z/OS

2 New Member
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. . .
Sep 12 '07 #1
0 1648

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

Similar topics

1
2712
by: Linda | last post by:
Hello! I am to develop a multi-lingual website / content management system. I will use ASP (IIS on swedish or english windows 2000), Access, and for the content editing i will use the built-in editor in IE (in an IFRAME). Primary languages/charsets, apart from the western languages (swedish, english etc) will be russian and arabic. Does anyone know how (if) this works?
1
4024
by: NohaKhalifa | last post by:
Dear All , I have a very big problem regarding using Arabic Character set . I'm Developing an Arabic Web Site using Asp and connecting to Access Database . but i have a problem retreiving data from database after i uploaded site to the hosing server .... All the arabic data retreived from database using Asp appears as question marks ??????? and only staic arabic written in asp pages appears well but which retreived from database...
17
8375
by: thinkfirst | last post by:
Hello CIWAH ... I want to propose full internationalization of three related websites: http://africadatabase.org/ http://people.africadatabase.org/ http://institutions.africadatabase.org/ My role is mainly advisory and server management. I have very little to do with content or page generation, so it's not something I can do myself -- I have to persuade other people to do it.
10
687
by: Christopher H. Laco | last post by:
Long story longer. I need to get web user input into a backend system that a) only grocks single byte encoding, b) expectes the data transer to be 1 bytes = 1 character, and c) uses the HP Roman-6 codepage system wide. As much as it sounds good, UTF/Unicode encoding is not an option, nor is changing the codepage. Tackling the first is easy via Encoding.Default.GetBytes and shoving it over the network. However, Encoding.Default is the...
18
9665
by: j1c | last post by:
What do I need to do in my ASP pages to display Arabic content? Does anything need to be done to the webserver too ? tx
8
8414
by: Kim Bundgaard | last post by:
Hi Anyone know where I can look for problem with codepage conversion between DB2 UDB Connect EE V8.2 (fixpak 3) and DB2 UDB z/OS V7. With DB2 UDB Connect EE V7.2 (fixpak 7) i get Ebcdic X'5A' converted to Ascii X'A4', but with V8 I get it converted to Ascii X'80'. I use Ebcdic codepage/ccsid 277 and client codepage 1252. It looks like a problem with Windows Latin-1 1252/5348 - the Euro codepage,
1
3956
by: Vladimir Khvostov | last post by:
Hi, We have some DB2 table on the host that has varchar(3200) columns that are used to store binary data (I know that "varchar(3200) for bit data" should have been used, by modifying host table is not an option at this time). I wrote a Win32 application, which is using DB2 Connect and ODBC to pull the data from the host. I am passing SQL_C_BINARY as a 3rd parameter in SQLBindCol() call, ::SQLBindCol(hStmt, nColNo + 1, SQL_C_BINARY,...
2
5014
by: mansour via DotNetMonster.com | last post by:
Dear all I am using ASP.NET 2003 and SQL SERVER 2000 I am building a website in English and Arabic. I am having a problem with Arabic characters, when I am trying to insert Arabic text it appears "????????" I have adjusted the page charset to "Arabic (Windows)" and Codepage to"1256" And in WEB.CONFIG to <globalization requestEncoding="windows-1256" responseEncoding="windows-1256" />
1
1922
by: CideoEspada | last post by:
I have a problem with my child asp pages, They seem to not recognize Arabic characters and display them as gibberish, while on the master pages or pages that are independent from master pages they display fine. I have tried a Meta tag in the header of the masterpage with a charset of UTF-8 and set the page tag CodePage of the ASP child page to 65001, but it still didn't work. The page is located at www.nazal-bahrain.com This page displays...
0
10164
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9986
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11577
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9896
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8256
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7431
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6118
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4948
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4540
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.