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,
but I can't find anything that can explain the why I get an 5348 codepage
when I use 1252 at the client.
Any suggestion welcome.
/Kim
8  8349 
Hi Kim,
It is an expected behaviour in v8. Microsoft changed the 1252 definition by
the addition of Euro symbol in x80 without changing the definition name to
5348. If you see the definition of 1252 in Microsoft web page now, you will
see Euro at x80. Microsoft 1252 is 5348.
If you want to go back to v7 behaviour, you need to copy two conversion
files, 02771252.cnv and IBM0277.ucs. The information is documented in the
following link: http://www-3.ibm.com/cgi-bin/db2www/...n=r0007951.htm
Download information and instruction is documented in the following link: http://www-3.ibm.com/cgi-bin/db2www/...n=t0004584.htm
Sherman
"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:3f***********************@dread15.news.tele.d k... 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, but I can't find anything that can explain the why I get an 5348 codepage
when I use 1252 at the client.
Any suggestion welcome.
/Kim
Hi
Thank you, but please explain why .....
The Windows client is the same (and so is the DB2 z/OS V7) - the only thing
I've changed is the DB2 UDB from V7 to V8.
As I understand the DRDA-session, it is the DRDA-Server that have to do the
translation of characteres from EBCDIC to Ascii - and from SYSSTRINGS
(277/1252) I can see that EBCDIC X'5A' translate to a X'A4' - and that is
what I get at the DB2 UDB V7.
But at V8 I get a X'80' (Euro-sign).
/Kim
"Sherman Lau" <sh***********@ca.ibm.com> wrote in message
news:bn**********@hanover.torolab.ibm.com... Hi Kim,
It is an expected behaviour in v8. Microsoft changed the 1252 definition
by the addition of Euro symbol in x80 without changing the definition name to
5348. If you see the definition of 1252 in Microsoft web page now, you
will see Euro at x80. Microsoft 1252 is 5348.
If you want to go back to v7 behaviour, you need to copy two conversion
files, 02771252.cnv and IBM0277.ucs. The information is documented in the
following link:
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce
nter.d2w/report?target=mainFrame&fn=r0007951.htm
Download information and instruction is documented in the following link:
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce
nter.d2w/report?target=mainFrame&fn=t0004584.htm
Sherman
"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:3f***********************@dread15.news.tele.d k... 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, but I can't find anything that can explain the why I get an 5348
codepage when I use 1252 at the client.
Any suggestion welcome.
/Kim
The receiver is doing the conversion in DRDA. When you select EBCDIC X'5A',
the DB2 UDB v8 client is converting EBCDCI X'5A' to 1252 X'80' using its
internal conversion table, not SYSIBM.SYSSTRINGS in DB2/zOS. If you replace
the UDB conversion table from the ftp site, UDB will read in the replaced
conversion table and convert the data to 1252 X'A4' for you.
Sherman
"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:3f***********************@dread15.news.tele.d k... Hi
Thank you, but please explain why .....
The Windows client is the same (and so is the DB2 z/OS V7) - the only
thing I've changed is the DB2 UDB from V7 to V8.
As I understand the DRDA-session, it is the DRDA-Server that have to do
the translation of characteres from EBCDIC to Ascii - and from SYSSTRINGS
(277/1252) I can see that EBCDIC X'5A' translate to a X'A4' - and that is
what I get at the DB2 UDB V7.
But at V8 I get a X'80' (Euro-sign).
/Kim
"Sherman Lau" <sh***********@ca.ibm.com> wrote in message
news:bn**********@hanover.torolab.ibm.com... Hi Kim,
It is an expected behaviour in v8. Microsoft changed the 1252 definition by the addition of Euro symbol in x80 without changing the definition name
to 5348. If you see the definition of 1252 in Microsoft web page now, you
will see Euro at x80. Microsoft 1252 is 5348.
If you want to go back to v7 behaviour, you need to copy two conversion
files, 02771252.cnv and IBM0277.ucs. The information is documented in
the following link:
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce nter.d2w/report?target=mainFrame&fn=r0007951.htm
Download information and instruction is documented in the following
link:
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce nter.d2w/report?target=mainFrame&fn=t0004584.htm
Sherman
"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:3f***********************@dread15.news.tele.d k... 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, but I can't find anything that can explain the why I get an 5348 codepage when I use 1252 at the client.
Any suggestion welcome.
/Kim
Hi Sherman
I'm a little confused.
Where is the translation actually happend ?
I always believe that the translation is occuring at the DRDA-Server - which
in my world is the DB2 z/OS. Because of all the SYSSTRINGS entries, and
problems not having the correct to/from CCSID in SYSSTRINGS.
In my example/world i have the following :
a) DRDA-Server : DB2 z/OS V7 (EBCDIC/CCSID 277)
b) DB2 Connect EE V7 as gateway
c) DB2 Runtime/Appl.Dev. Client (Ascii/codepage 1252)
When I at c) select data from a) - where is the translation from EBCDIC to
Ascii going on ?
At a), b) or c) ?
Is it both a) and 3), or b), or c) ?
/Kim
"Sherman Lau" <sh***********@ca.ibm.com> wrote in message
news:bn**********@hanover.torolab.ibm.com... The receiver is doing the conversion in DRDA. When you select EBCDIC
X'5A', the DB2 UDB v8 client is converting EBCDCI X'5A' to 1252 X'80' using its
internal conversion table, not SYSIBM.SYSSTRINGS in DB2/zOS. If you
replace the UDB conversion table from the ftp site, UDB will read in the replaced
conversion table and convert the data to 1252 X'A4' for you.
Sherman
"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:3f***********************@dread15.news.tele.d k... Hi
Thank you, but please explain why .....
The Windows client is the same (and so is the DB2 z/OS V7) - the only thing I've changed is the DB2 UDB from V7 to V8.
As I understand the DRDA-session, it is the DRDA-Server that have to do
the translation of characteres from EBCDIC to Ascii - and from SYSSTRINGS
(277/1252) I can see that EBCDIC X'5A' translate to a X'A4' - and that
is what I get at the DB2 UDB V7.
But at V8 I get a X'80' (Euro-sign).
/Kim
"Sherman Lau" <sh***********@ca.ibm.com> wrote in message
news:bn**********@hanover.torolab.ibm.com... Hi Kim,
It is an expected behaviour in v8. Microsoft changed the 1252
definition by the addition of Euro symbol in x80 without changing the definition
name to 5348. If you see the definition of 1252 in Microsoft web page now, you
will see Euro at x80. Microsoft 1252 is 5348.
If you want to go back to v7 behaviour, you need to copy two
conversion files, 02771252.cnv and IBM0277.ucs. The information is documented in
the following link:
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce nter.d2w/report?target=mainFrame&fn=r0007951.htm
Download information and instruction is documented in the following link:
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce nter.d2w/report?target=mainFrame&fn=t0004584.htm
Sherman
"Kim Bundgaard" <kib at kmd.dk> wrote in message
news:3f***********************@dread15.news.tele.d k...
> 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,
> but I can't find anything that can explain the why I get an 5348
codepage > when I use 1252 at the client.
>
> Any suggestion welcome.
>
> /Kim
>
>
DB2 always translates at the receiving end.
Regards Rolf
Kim,
Rolf is correct. Let me show you an example.
Windows 1252 client. zOS 227 server.
If you insert a record from the client to the server, the server will do the
data conversion from 1252 to 227.
If you select a record from the server to the client, the client will do the
data conversion from 227 to 1252.
In your case, you are doing a select, your client is doing the conversion
for you.
Sherman
"Rolf Loeben" <ro*********@online.de> wrote in message
news:bn************@ID-207325.news.uni-berlin.de... DB2 always translates at the receiving end.
Regards Rolf
Hi Sherman (and Rolf)
Okay - I understand. I have to change my understanding of codepage
translation bewteen DB2 z/OS and DB2 UDB Runtime Client.
I can be a little insecure about IBM changing the translation without doing
a BIG ALARM in the "News for DB2 UDB V8".
It's a little inconvenient to distribute an alternative .cnv file to all my
clients because of the change.
Thank you for your comments to my misleading understanding.
Regards
Kim
"Sherman Lau" <sh***********@ca.ibm.com> wrote in message
news:bn**********@hanover.torolab.ibm.com... Kim,
Rolf is correct. Let me show you an example.
Windows 1252 client. zOS 227 server.
If you insert a record from the client to the server, the server will do
the data conversion from 1252 to 227.
If you select a record from the server to the client, the client will do
the data conversion from 227 to 1252.
In your case, you are doing a select, your client is doing the conversion
for you.
Sherman
"Rolf Loeben" <ro*********@online.de> wrote in message
news:bn************@ID-207325.news.uni-berlin.de... DB2 always translates at the receiving end.
Regards Rolf
Hi
When i download the 02771252.cnv file to x:\sqllib\conv, my application
crashes/abend (there where no 02771252.cnv to replcae).
I've done a binary download.
By the way - when I use the default DB2 UDB V8 to insert/select data to/from
DB2 z/OS i get the "general currency symbol" and the "Euro sign" converted.
When I insert the Ascii hex is X'A4' for "general currency sign" and X'80"
for Euro sign.
In DB2 z/OS it become EBCDIC X'20' and X'5A'
When I select the row again, I get EBCDIC X'20' returned as Ascii X'A4' and
EBCDIC X'5A' as Ascii X'80' - the sign changed ...
/Kim
"Sherman Lau" <sh***********@ca.ibm.com> wrote in message
news:bn**********@hanover.torolab.ibm.com... Kim,
Rolf is correct. Let me show you an example.
Windows 1252 client. zOS 227 server.
If you insert a record from the client to the server, the server will do
the data conversion from 1252 to 227.
If you select a record from the server to the client, the client will do
the data conversion from 227 to 1252.
In your case, you are doing a select, your client is doing the conversion
for you.
Sherman
"Rolf Loeben" <ro*********@online.de> wrote in message
news:bn************@ID-207325.news.uni-berlin.de... DB2 always translates at the receiving end.
Regards Rolf
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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
|
by: Vijay Kumar R Zanvar |
last post by:
I have following questions:
1. Appendix C of K&R says:
Trigraph sequences introduced by ?? allow
representation of characters lacking in some
character sets. ...
Can somebody explain how...
|
by: Martín Marconcini |
last post by:
Hello there,
I'm writting (or trying to) a Console Application in C#. I has to be
console.
I remember back in the old days of Cobol (Unisys), Clipper and even Basic,
I used to use a program...
|
by: Sonu |
last post by:
Hello,
I have a multilingual application, to which I am adding Russian. The prolem
is that all the dialog boxes & Menus are showing junk characters instead of
Cyrillics!!
while my window contents...
|
by: JJBW |
last post by:
Hi
I am creating some aspx files in Visual Studio 2003 for a Danish web
site.
The page is encoded as UTF-8 - However, when I save the the aspx file
as "UTF-8 without signature" the Danish...
|
by: JNariss |
last post by:
Hello,
I have created a connection to my Access database with Dreamweaver and
made a simple form with 4 fields.
The code behind this form was/is:
<%@LANGUAGE="VBCRIPT" CODEPAGE="1252"%>...
|
by: Matt |
last post by:
I originally posted this in microsoft.public.sqlserver.server, and it
was suggested that I post here.
I'm having problems with searches via a classic ASP front-end of terms
including foreign...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
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,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
