| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Data Conversion using CCSID |
« View previous topic :: View next topic » |
| Author |
Message
|
| bay hoe san |
 Posted: Mon Mar 19, 2007 9:25 pm Post subject: Data Conversion using CCSID |
 |
|
Centurion
Joined: 27 Nov 2006
Posts: 117
|
Hello,
( 1) The table 01F404E4.tbl in my Windows server MQ directory is being used to do the data conversion for messages received from z/OS.
( 2) How to interpret the table 01F404E4.tbl? I meant to say how to use the table to demostrate that the number 10 in EBCDIC X'F1F0' is being converted to X'3130'?
( 3) Pls advise.
Thank you.
.Hoe San. |
|
| Back to top |
|
 |
| Nigelg |
| Posted: Tue Mar 20, 2007 1:39 am Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
The source char is represented by its position in the table, and the destination char is the char at that position.
In the example, the char at position xF0 should be x30, and at xF1 the char should be x31.
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
| bay hoe san |
| Posted: Tue Mar 20, 2007 6:48 pm Post subject: |
|
|
Centurion
Joined: 27 Nov 2006
Posts: 117
|
Hello Nigelg,
( 1) Thanks for your prompt response.
( 2) How about space represented in hex '40' in EBCDIC in z/OS is represented in Windows if we use the table 01F404E4.tbl? (i.e. z/OS CCSID 500 and Windows CCSID 1252? How to interpret space in this table?
( 3) Once again, thank you and greatly appreciate.
.Hoe San. |
|
| Back to top |
|
|
| Nigelg |
| Posted: Wed Mar 21, 2007 12:10 am Post subject: |
|
|
Grand Master
Joined: 02 Aug 2004
Posts: 1046
|
The space char in 500 x40 is no different from any other char. Look at position x40 in the table, and the char at that position is the char in the destination code page.
Here is a hex dump of the table (from Solaris, but the table is the same)
| Code: |
/opt/mqm/lib/iconv $ hex16 01F404E4.tbl
File: 01F404E4.tbl offset 0
00000000: 00010203 9C09867F 978D8E0B 0C0D0E0F ................
00000010: 10111213 9D850887 1819928F 1C1D1E1F ................
00000020: 80818283 840A171B 88898A8B 8C050607 ................
00000030: 90911693 94959604 98999A9B 14159E1A ................
00000040: 20A0E2E4 E0E1E3E5 E7F15B2E 3C282B21 .........[.<(+!
00000050: 26E9EAEB E8EDEEEF ECDF5D24 2A293B5E &.........]$*);^
00000060: 2D2FC2C4 C0C1C3C5 C7D1A62C 255F3E3F -/.........,%_>?
00000070: F8C9CACB C8CDCECF CC603A23 40273D22 .........`:#@'="
00000080: D8616263 64656667 6869ABBB F0FDFEB1 .abcdefghi......
00000090: B06A6B6C 6D6E6F70 7172AABA E6B8C6A4 .jklmnopqr......
000000A0: B57E7374 75767778 797AA1BF D0DDDEAE .~stuvwxyz......
000000B0: A2A3A5B7 A9A7B6BC BDBEAC7C AFA8B4D7 ...........|....
000000C0: 7B414243 44454647 4849ADF4 F6F2F3F5 {ABCDEFGHI......
000000D0: 7D4A4B4C 4D4E4F50 5152B9FB FCF9FAFF }JKLMNOPQR......
000000E0: 5CF75354 55565758 595AB2D4 D6D2D3D5 \.STUVWXYZ......
000000F0: 30313233 34353637 3839B3DB DCD9DA9F 0123456789......
|
You can see that the char at x40 is x20, the representation of space in 1252.
BTW for those who might be interested, 1252 is the Euro-enabled version of the normal Windows code page 437.
_________________
MQSeries.net helps those who help themselves.. |
|
| Back to top |
|
|
| bay hoe san |
| Posted: Wed Mar 21, 2007 1:10 am Post subject: |
|
|
Centurion
Joined: 27 Nov 2006
Posts: 117
|
Hello Nigelg,
( 1) Understood. Thank you very much for your help.
.Hoe San. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
