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" <shermanNOSPAM@ca.ibm.com> wrote in message
news:bn9c2q$rqj$1@hanover.torolab.ibm.com...[color=blue]
> The receiver is doing the conversion in DRDA. When you select EBCDIC[/color]
X'5A',[color=blue]
> 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[/color]
replace[color=blue]
> 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:3f983005$1$29390$edfadb0f@dread15.news.tele.d k...[color=green]
> > Hi
> >
> > Thank you, but please explain why .....
> >
> > The Windows client is the same (and so is the DB2 z/OS V7) - the only[/color]
> thing[color=green]
> > 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[/color]
> the[color=green]
> > 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[/color][/color]
is[color=blue][color=green]
> > what I get at the DB2 UDB V7.
> >
> > But at V8 I get a X'80' (Euro-sign).
> >
> > /Kim
> >
> > "Sherman Lau" <shermanNOSPAM@ca.ibm.com> wrote in message
> > news:bn8lpb$obs$1@hanover.torolab.ibm.com...[color=darkred]
> > > Hi Kim,
> > >
> > > It is an expected behaviour in v8. Microsoft changed the 1252[/color][/color][/color]
definition[color=blue][color=green]
> > by[color=darkred]
> > > the addition of Euro symbol in x80 without changing the definition[/color][/color][/color]
name[color=blue]
> to[color=green][color=darkred]
> > > 5348. If you see the definition of 1252 in Microsoft web page now, you[/color]
> > will[color=darkred]
> > > see Euro at x80. Microsoft 1252 is 5348.
> > >
> > > If you want to go back to v7 behaviour, you need to copy two[/color][/color][/color]
conversion[color=blue][color=green][color=darkred]
> > > files, 02771252.cnv and IBM0277.ucs. The information is documented in[/color][/color]
> the[color=green][color=darkred]
> > > following link:
> > >[/color]
> >[/color]
>[/color]
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce[color=blue][color=green]
> > nter.d2w/report?target=mainFrame&fn=r0007951.htm[color=darkred]
> > >
> > > Download information and instruction is documented in the following[/color][/color]
> link:[color=green][color=darkred]
> > >[/color]
> >[/color]
>[/color]
http://www-3.ibm.com/cgi-bin/db2www/...pport/v8infoce[color=blue][color=green]
> > nter.d2w/report?target=mainFrame&fn=t0004584.htm[color=darkred]
> > >
> > >
> > > Sherman
> > >
> > > "Kim Bundgaard" <kib at kmd.dk> wrote in message
> > > news:3f97bf34$0$29381$edfadb0f@dread15.news.tele.d k...
> > > > Hi
> > > >
> > > > Anyone know where I can look for problem with codepage conversion[/color]
> > between[color=darkred]
> > > > 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[/color][/color]
> to[color=green][color=darkred]
> > > > 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[/color]
> > codepage[color=darkred]
> > > > when I use 1252 at the client.
> > > >
> > > > Any suggestion welcome.
> > > >
> > > > /Kim
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
