Professional Web Applications Themes

DB2 UDB V7 & V8 codepage difference - DB2 z/OS ? - IBM DB2

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

  1. #1

    Default DB2 UDB V7 & V8 codepage difference - DB2 z/OS ?

    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


    Kim Guest

  2. #2

    Default Re: DB2 UDB V7 & V8 codepage difference - DB2 z/OS ?

    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 doented in the
    following link:
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=r0007951.htm

    Download information and instruction is doented in the following link:
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infocenter.d2w/report?target=mainFrame&fn=t0004584.htm


    Sherman

    "Kim Bundgaard" <kib at kmd.dk> wrote in message
    news:3f97bf34$0$29381$news.tele.dk... 
    codepage, 


    Sherman Guest

  3. #3

    Default Re: DB2 UDB V7 & V8 codepage difference - DB2 z/OS ?

    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" <ibm.com> wrote in message
    news:bn8lpb$obs$torolab.ibm.com... 
    by 
    will 
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce
    nter.d2w/report?target=mainFrame&fn=r0007951.htm 
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce
    nter.d2w/report?target=mainFrame&fn=t0004584.htm [/ref]
    between 
    > codepage, [/ref]
    codepage 
    >
    >[/ref]


    Kim Guest

  4. #4

    Default Re: DB2 UDB V7 & V8 codepage difference - DB2 z/OS ?

    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:3f983005$1$29390$news.tele.dk... 
    thing 
    the 
    > by [/ref]
    to 
    > will [/ref]
    the 
    >[/ref]
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce [/ref]
    link: 
    >[/ref]
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8infoce [/ref]
    > between [/ref][/ref]
    to 
    > > codepage, [/ref]
    > codepage 
    > >
    > >[/ref]
    >
    >[/ref]


    Sherman Guest

Similar Threads

  1. codepage setting, \encoding
    By perico@12move.nl in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: February 1st, 09:20 PM
  2. codepage iso-8859-2 via ODBC
    By ElaK in forum PHP Development
    Replies: 0
    Last Post: June 14th, 08:45 PM
  3. Response.CodePage
    By Steve Kushubar in forum ASP
    Replies: 4
    Last Post: September 26th, 09:37 AM
  4. DB2 Codepage conversion problem with XML
    By cma2 in forum IBM DB2
    Replies: 1
    Last Post: September 10th, 12:21 PM
  5. DB2Connect V8 Codepage error
    By Andrey in forum IBM DB2
    Replies: 0
    Last Post: August 11th, 12:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139