I oppologize for my last unreadable post. I have attached a notepad view
for easier viewing of the hex dumps of the character translations using
iconv.
Thanks
Frank
-----Original Message-----
From: Bright, Frank [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 3:46 PM
To: [EMAIL PROTECTED]
Subject: Re: CCSID 037
I think I have figured out the iconv command syntax and the correct CCSID
names. The below shows what characters get changed and which remain the
same.
On the V5.3 MQ Client I can see a readme.ccs that provides the name for 1051
CCSIDs that can be used in the iconv:
041B0025 From 1051 to 37. SBCS using CDRA roundtrip algorithm 2.
('ASCII roman8 for HP Western European' to 'EBCDIC US
English'),
I performed the iconv using roman8 for 1051 CCSID below.
mcfl1u2u mqm->iconv -f roman8 -t cp037 character.file>character.cp037
Dump output file that should be EBCDIC after convert:
mcfl1u2u mqm->/home/mqm/bin/temp/dumpfile character.cp037
00 01 02 03 37 2D 2E 2F - 16 05 25 0B 0C 0D 0E 0F | ????7-./ - ??%????? 10
11 12 13 3C 3D 32 26 - 18 19 3F 27 1C 1D 1E 1F | ????<=2& - ???'???? 40 5A
7F 7B 5B 6C 50 7D - 4D 5D 5C 4E 6B 60 4B 61 | @Z?{[lP} - M]\Nk`Ka F0 F1 F2
F3 F4 F5 F6 F7 - F8 F9 7A 5E 4C 7E 6E 6F | ???????? - ??z^L~no 7C C1 C2 C3
C4 C5 C6 C7 - C8 C9 D1 D2 D3 D4 D5 D6 | |??????? - ???????? D7 D8 D9 E2 E3
E4 E5 E6 - E7 E8 E9 BA E0 BB B0 6D | ???????? - ???????m 79 81 82 83 84 85
86 87 - 88 89 91 92 93 94 95 96 | y??????? - ???????? 97 98 99 A2 A3 A4 A5
A6 - A7 A8 A9 C0 4F D0 A1 07 | ???????? - ????O??? 20 21 22 23 24 15 06 17 -
28 29 2A 2B 2C 09 0A 1B | !"#$??? - ()*+,??? 30 31 1A 33 34 35 36 08 - 38
39 3A 3B 04 14 3E FF | 01?3456? - 89:;??>? 41 64 62 74 72 73 76 77 - BE 79
B0 BD A1 FD FB B1 | Adbtrsvw - ?y?????? BC AD 8D 90 68 48 69 49 - AA AB 9F
B1 B2 B5 86 4A | ????hHiI - ???????J 42 52 CB DB 45 51 CE DE - 44 54 CD DD
43 53 CC DC | BR??EQ?? - DT??CS?? 67 56 80 9E 47 55 70 9C - 63 58 EC FC 71
57 59 EB | gV??GUp? - cX??qWY? 65 66 46 AC 8C 75 78 EE - ED EF CF E2 A2 FE
E8 DF | efF??ux? - ???????? AE 8E B3 A0 B6 B9 60 B7 - B8 9A 9B 8A 5C 8B 8F
41 | ??????`? - ????\??A 7C 7C 7C 7C 7C 7C 7C 7C - 7C 7C 7C 7C 7C 7C 7C 7C |
|||||||| - |||||||| 7C 7C 7C 7C 7C 7C 7C 7C - 7C 7C 7C 7C 7C 7C 7C 7C |
|||||||| - |||||||| 7C 7C 7C 7C 7C 7C 7C 7C - 7C 7C 7C 7C 7C 7C 7C 7C |
|||||||| - |||||||| 7C 7C 7C 7C 7C 7C 7C 7C - ED EF CF E2 A2 FE E8 DF |
|||||||| - ????????
ASCII file used as input for the convert:
mcfl1u2u mqm->/home/mqm/bin/temp/dumpfile character.file
00 01 02 03 04 05 06 07 - 08 09 0A 0B 0C 0D 0E 0F | ???????? - ???????? 10
11 12 13 14 15 16 17 - 18 19 1A 1B 1C 1D 1E 1F | ???????? - ???????? 20 21
22 23 24 25 26 27 - 28 29 2A 2B 2C 2D 2E 2F | !"#$%&' - ()*+,-./ 30 31 32
33 34 35 36 37 - 38 39 3A 3B 3C 3D 3E 3F | 01234567 - 89:;<=>? 40 41 42 43
44 45 46 47 - 48 49 4A 4B 4C 4D 4E 4F | @ABCDEFG - HIJKLMNO 50 51 52 53 54
55 56 57 - 58 59 5A 5B 5C 5D 5E 5F | PQRSTUVW - XYZ[\]^_ 60 61 62 63 64 65
66 67 - 68 69 6A 6B 6C 6D 6E 6F | `abcdefg - hijklmno 70 71 72 73 74 75 76
77 - 78 79 7A 7B 7C 7D 7E 7F | pqrstuvw - xyz{|}~? 80 81 82 83 84 85 86 87 -
88 89 8A 8B 8C 8D 8E 8F | ???????? - ???????? 90 91 92 93 94 95 96 97 - 98
99 9A 9B 9C 9D 9E 9F | ???????? - ???????? A0 A1 A2 A3 A4 A5 A6 A7 - A8 A9
AA AB AC AD AE AF | ???????? - ???????? B0 B1 B2 B3 B4 B5 B6 B7 - B8 B9 BA
BB BC BD BE BF | ???????? - ???????? C0 C1 C2 C3 C4 C5 C6 C7 - C8 C9 CA CB
CC CD CE CF | ???????? - ???????? D0 D1 D2 D3 D4 D5 D6 D7 - D8 D9 DA DB DC
DD DE DF | ???????? - ???????? E0 E1 E2 E3 E4 E5 E6 E7 - E8 E9 EA EB EC ED
EE EF | ???????? - ???????? F0 F1 F2 F3 F4 F5 F6 F7 - F8 F9 FA FB FC FD FE
FF | ???????? - ???????? 40 40 40 40 40 40 40 40 - 40 40 40 40 40 40 40 40 |
@@@@@@@@ - @@@@@@@@ 40 40 40 40 40 40 40 40 - 40 40 40 40 40 40 40 40 |
@@@@@@@@ - @@@@@@@@ 40 40 40 40 40 40 40 40 - 40 40 40 40 40 40 40 40 |
@@@@@@@@ - @@@@@@@@ 40 40 40 40 40 40 40 40 - E8 E9 EA EB EC ED EE EF |
@@@@@@@@ - ????????
Thanks
Frank
201-269-4071
-----Original Message-----
From: Bright, Frank
Sent: Thursday, August 14, 2003 11:44 AM
To: 'MQSeries List'
Subject: RE: CCSID 037
Thanks Bobbee
-----Original Message-----
From: Robert Broderick [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 14, 2003 10:49 AM
To: [EMAIL PROTECTED]
Subject: Re: CCSID 037
SCSQAUTH(CSQA0025), I think is right. I also see the rest of the code sets
in there. You convert from code set should be in the 418 one.
BROWSE MQS$.PKGP.SCSQAUTH Row 00419 of
01787
Command ===> Scroll ===>
PAGE
Name Prompt Alias-of Size TTR AC AM
RM
_________ CSQA0413 00000200 003B31 00 31
ANY
_________ CSQA0414 00000200 003B38 00 31
ANY
_________ CSQA0415 00000200 003B3F 00 31
ANY
_________ CSQA0416 00000200 003B46 00 31
ANY
_________ CSQA0417 00000200 003C03 00 31
ANY
_________ CSQA0418 00000200 003C0A 00 31
ANY
bobbee
>From: "Bright, Frank" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: CCSID 037
>Date: Thu, 14 Aug 2003 09:53:27 -0400
>
>Based on Bobbee's recollection, I started looking into the various data
>sets on OS/390. In SCSQAUTH(CSQA0025), I think I have found the 037
>character table, but I am not sure. When I shift to the right by 256
>bytes while browsing in hex, I see the EBCDIC character translation
>list of characters by ASCII relative byte offset in decimal. For
>example, an ASCII number 0 is decimal 48. When I shift to the right
>256 to get to the beginning of the EBCDIC translation and then another
>48 bytes for ASCII number 0, I see EBCDIC number zero or a hex 'F0'.
>The aphabit seems to line up as well.
>
>Does this sound right to anyone?
>
>Thanks
> Frank
>
>-----Original Message-----
>From: Bright, Frank [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 14, 2003 8:53 AM
>To: [EMAIL PROTECTED]
>Subject: Re: CCSID 037
>
>
>Thanks Bobbee
>
>I found the below within IBM site last night, however it would only
>show me the 037 code page detail. At the same site is a pointer to
>CDRA (Character Data Representation Architecture) reference guide which
>gives a lot of detail about how translations work. It quite an effort
>to look through to determine how two code pages work together.
>
>http://www-1.ibm.com/servers/eserver/iseries/software/globalization/ccs
>id_li
>st.html
>
>I will try to find out about the SENDingHEXRECIEVingHEX.tbl.
>
>
>Thanks
> Frank
> 201-269-4071
>
>
>-----Original Message-----
>From: Robert Broderick [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 14, 2003 8:06 AM
>To: [EMAIL PROTECTED]
>Subject: Re: CCSID 037
>
>
>Frank,
>There is a WEB site at IBM where ALL the CCSIDs are displayed in table
>format with their binary code and character representation. I just
>tried to find it and could not. I have seen it supplied by members on
>the LIST. Maybe someone has it booked marked. I used it when I was
>having some conversion problems at a client. Maybe someone on the
>LISThas the link.
>
>Other than that. If I remember correctly. Convert your SENDing CCSID to
>a hex value and your RECIEVing CCSID to a hex value. Find the table as
>SENDingHEXRECIEVingHEX.tbl on the system. The mainframe has it
>somewhere that is not easy to find.
>
>The SENDing character is used as a displacement into the table and the
>character at that position is used as the replacement.
>
>It has been a while so I HOPE I have this right. On the mainframe the
>TABLES are somewhere strange and are proceeded with an "A". Not exactly
>sure where they are.
>
>Hope this helps.
>
> bobbee
>
>
> >From: "Bright, Frank" <[EMAIL PROTECTED]>
> >Reply-To: MQSeries List <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: CCSID 037
> >Date: Wed, 13 Aug 2003 19:37:52 -0400
> >
> >I am getting questioned on the mapping of ASCII to EBCDIC characters
> >between UNIX and OS/390 under MQ.
> >
> >The character sets (CCSIDs) being used are: UNIX (1051) and OS/390
> >(037). I tried to find a document that would just show the code
> >character set mappings character by character but I could not find
> >one. I attempted to use iconv command in UNIX to show the character
> >mappings implicitly but I am not sure of what the 1051 or 037
> >character set is equivalent to in the iconv.config.
> >
> >I tried the following as a best guess using iconv command under UNIX
> >just to see what happens:
> >
> >/usr/bin/iconv -f iso81 -t cp037 character.file > characters.cp037
> >
> >I then FTP'd characters.cp037 over to OS/390 for a look see. It was
> >close but no cigar.
> >
> >Could someone tell me what 1051 & 037 is equivalent to in the
> >iconv.config file?
> >
> >Is this how others figure out how the conversion occurs between
> >CCSIDs across platforms?
> >
> >Is there a better way to decipher CCSID translation that someone
> >could suggest?
> >
> >
> >Thanks
> > Frank
> > 201-269-4071
> >
> >
> >
> >This e-mail message and any attachments contain confidential
> >information from Medco Health Solutions, Inc. If you are not the
> >intended recipient, you are hereby notified that disclosure,
> >printing, copying, distribution, or the taking of any action in
> >reliance on the contents of this electronic information is strictly
> >prohibited. If you have received this e-mail message in error, please
> >immediately notify the sender by reply message and then delete the
> >electronic message and any attachments.
> >
> >Instructions for managing your mailing list subscription are provided
> >in the Listserv General Users Guide available at http://www.lsoft.com
> >Archive: http://vm.akh-wien.ac.at/MQSeries.archive
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8.
>http://join.msn.com/?page=features/junkmail
>
>Instructions for managing your mailing list subscription are provided
>in the Listserv General Users Guide available at http://www.lsoft.com
>Archive: http://vm.akh-wien.ac.at/MQSeries.archive
>
>
>This e-mail message and any attachments contain confidential
>information from Medco Health Solutions, Inc. If you are not the
>intended recipient, you are hereby notified that disclosure, printing,
>copying, distribution, or the taking of any action in reliance on the
>contents of this electronic information is strictly prohibited. If you
>have received this e-mail message
>in error, please immediately notify the sender by reply message and then
>delete the electronic message and any attachments.
>
>Instructions for managing your mailing list subscription are provided
>in the Listserv General Users Guide available at http://www.lsoft.com
>Archive: http://vm.akh-wien.ac.at/MQSeries.archive
>
>
>This e-mail message and any attachments contain confidential
>information from Medco Health Solutions, Inc. If you are not the
>intended recipient, you are hereby notified that disclosure, printing,
>copying, distribution, or the taking of any action in reliance on the
>contents of this electronic information is strictly prohibited. If you
>have received this e-mail message in error, please immediately notify
>the sender by reply message and then delete the electronic message and
>any attachments.
>
>Instructions for managing your mailing list subscription are provided
>in the Listserv General Users Guide available at http://www.lsoft.com
>Archive: http://vm.akh-wien.ac.at/MQSeries.archive
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
Instructions for managing your mailing list subscription are provided in the
Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
This e-mail message and any attachments contain confidential information
from Medco Health Solutions, Inc. If you are not the intended recipient,
you are hereby notified that disclosure, printing, copying, distribution,
or the taking of any action in reliance on the contents of this electronic
information is strictly prohibited. If you have received this e-mail message
in error, please immediately notify the sender by reply message and then
delete the electronic message and any attachments.
Instructions for managing your mailing list subscription are provided in the
Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
This e-mail message and any attachments contain confidential information from Medco
Health Solutions, Inc. If you are not the intended recipient, you are hereby notified
that disclosure, printing, copying, distribution, or the taking of any action in
reliance on the contents of this electronic information is strictly prohibited. If you
have received this e-mail message in error, please immediately notify the sender by
reply message and then delete the electronic message and any attachments.
mcfl1u2u mqm->iconv -f roman8 -t cp037 character.file>character.cp037
mcfl1u2u mqm->/home/mqm/bin/temp/dumpfile character.cp037
00 01 02 03 37 2D 2E 2F - 16 05 25 0B 0C 0D 0E 0F | ????7-./ - ??%?????
10 11 12 13 3C 3D 32 26 - 18 19 3F 27 1C 1D 1E 1F | ????<=2& - ???'????
40 5A 7F 7B 5B 6C 50 7D - 4D 5D 5C 4E 6B 60 4B 61 | @Z?{[lP} - M]\Nk`Ka
F0 F1 F2 F3 F4 F5 F6 F7 - F8 F9 7A 5E 4C 7E 6E 6F | ???????? - ??z^L~no
7C C1 C2 C3 C4 C5 C6 C7 - C8 C9 D1 D2 D3 D4 D5 D6 | |??????? - ????????
D7 D8 D9 E2 E3 E4 E5 E6 - E7 E8 E9 BA E0 BB B0 6D | ???????? - ???????m
79 81 82 83 84 85 86 87 - 88 89 91 92 93 94 95 96 | y??????? - ????????
97 98 99 A2 A3 A4 A5 A6 - A7 A8 A9 C0 4F D0 A1 07 | ???????? - ????O???
20 21 22 23 24 15 06 17 - 28 29 2A 2B 2C 09 0A 1B | !"#$??? - ()*+,???
30 31 1A 33 34 35 36 08 - 38 39 3A 3B 04 14 3E FF | 01?3456? - 89:;??>?
41 64 62 74 72 73 76 77 - BE 79 B0 BD A1 FD FB B1 | Adbtrsvw - ?y??????
BC AD 8D 90 68 48 69 49 - AA AB 9F B1 B2 B5 86 4A | ????hHiI - ???????J
42 52 CB DB 45 51 CE DE - 44 54 CD DD 43 53 CC DC | BR??EQ?? - DT??CS??
67 56 80 9E 47 55 70 9C - 63 58 EC FC 71 57 59 EB | gV??GUp? - cX??qWY?
65 66 46 AC 8C 75 78 EE - ED EF CF E2 A2 FE E8 DF | efF??ux? - ????????
AE 8E B3 A0 B6 B9 60 B7 - B8 9A 9B 8A 5C 8B 8F 41 | ??????`? - ????\??A
7C 7C 7C 7C 7C 7C 7C 7C - 7C 7C 7C 7C 7C 7C 7C 7C | |||||||| - ||||||||
7C 7C 7C 7C 7C 7C 7C 7C - 7C 7C 7C 7C 7C 7C 7C 7C | |||||||| - ||||||||
7C 7C 7C 7C 7C 7C 7C 7C - 7C 7C 7C 7C 7C 7C 7C 7C | |||||||| - ||||||||
7C 7C 7C 7C 7C 7C 7C 7C - ED EF CF E2 A2 FE E8 DF | |||||||| - ????????
mcfl1u2u mqm->/home/mqm/bin/temp/dumpfile character.file
00 01 02 03 04 05 06 07 - 08 09 0A 0B 0C 0D 0E 0F | ???????? - ????????
10 11 12 13 14 15 16 17 - 18 19 1A 1B 1C 1D 1E 1F | ???????? - ????????
20 21 22 23 24 25 26 27 - 28 29 2A 2B 2C 2D 2E 2F | !"#$%&' - ()*+,-./
30 31 32 33 34 35 36 37 - 38 39 3A 3B 3C 3D 3E 3F | 01234567 - 89:;<=>?
40 41 42 43 44 45 46 47 - 48 49 4A 4B 4C 4D 4E 4F | @ABCDEFG - HIJKLMNO
50 51 52 53 54 55 56 57 - 58 59 5A 5B 5C 5D 5E 5F | PQRSTUVW - XYZ[\]^_
60 61 62 63 64 65 66 67 - 68 69 6A 6B 6C 6D 6E 6F | `abcdefg - hijklmno
70 71 72 73 74 75 76 77 - 78 79 7A 7B 7C 7D 7E 7F | pqrstuvw - xyz{|}~?
80 81 82 83 84 85 86 87 - 88 89 8A 8B 8C 8D 8E 8F | ???????? - ????????
90 91 92 93 94 95 96 97 - 98 99 9A 9B 9C 9D 9E 9F | ???????? - ????????
A0 A1 A2 A3 A4 A5 A6 A7 - A8 A9 AA AB AC AD AE AF | ???????? - ????????
B0 B1 B2 B3 B4 B5 B6 B7 - B8 B9 BA BB BC BD BE BF | ???????? - ????????
C0 C1 C2 C3 C4 C5 C6 C7 - C8 C9 CA CB CC CD CE CF | ???????? - ????????
D0 D1 D2 D3 D4 D5 D6 D7 - D8 D9 DA DB DC DD DE DF | ???????? - ????????
E0 E1 E2 E3 E4 E5 E6 E7 - E8 E9 EA EB EC ED EE EF | ???????? - ????????
F0 F1 F2 F3 F4 F5 F6 F7 - F8 F9 FA FB FC FD FE FF | ???????? - ????????
40 40 40 40 40 40 40 40 - 40 40 40 40 40 40 40 40 | @@@@@@@@ - @@@@@@@@
40 40 40 40 40 40 40 40 - 40 40 40 40 40 40 40 40 | @@@@@@@@ - @@@@@@@@
40 40 40 40 40 40 40 40 - 40 40 40 40 40 40 40 40 | @@@@@@@@ - @@@@@@@@
40 40 40 40 40 40 40 40 - E8 E9 EA EB EC ED EE EF | @@@@@@@@ - ????????
