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
>
>