| Author |
Message
|
| mvsivaiah |
 Posted: Fri Sep 12, 2008 4:13 am Post subject: EBCDIC to ASCII conversion ???? |
 |
|
Apprentice
Joined: 30 May 2008
Posts: 25
|
Hi,
I tried the flow (fileinput-->emailoutput) for sending a USS file to lotusnotes mail as an attachment. The USS file is full of EBCDIC chars (but can be readable in USS). The lotusnotes mail is getting the attachment with EBCDIC code, which can't be in readable format.
So, I planned to use Compute node in between FileInput node and EmailOutput node, which converts the file to ASCII format.
How the inputroot to be CASTed in the esql?
Also note me how to read the element into EmailOutput Node.
How the esql code look like for this task? 
_________________
Venkat. |
|
| Back to top |
|
 |
| MrSmith |
| Posted: Fri Sep 12, 2008 6:48 am Post subject: |
|
|
Master
Joined: 20 Mar 2008
Posts: 215
|
| the body of the message will be in EBCDIC yes? and therefore you can cast as a bitstream the incoming "body" of the message i.e your EBCDIC stream to the ASCII CCSID and Encoding of the platform you wish to send to. Look in the help for the quirks and rules on ASBITSTREAM function. Then set that as the output body for your email node |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Sep 12, 2008 6:55 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Of course, there's no reason to do this when all you have to do is make sure the OutputRoot.Properties are correct. |
|
| Back to top |
|
|
| mvsivaiah |
| Posted: Fri Sep 12, 2008 7:19 am Post subject: |
|
|
Apprentice
Joined: 30 May 2008
Posts: 25
|
Mnay Thanks Mr.Smith and mqjeff for your quick replies.
I've a doubt over here: Are there fixed values of CCSID and encoding for platforms? Also, I'm not sure, Lotus notes come under which platform?
Could you please guess for me the possible CCSID and encoding values?
Thank you.
_________________
Venkat. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Sep 12, 2008 7:25 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Sep 12, 2008 7:32 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| mvsivaiah wrote: |
Mnay Thanks Mr.Smith and mqjeff for your quick replies.
I've a doubt over here: Are there fixed values of CCSID and encoding for platforms? Also, I'm not sure, Lotus notes come under which platform?
Could you please guess for me the possible CCSID and encoding values?
Thank you. |
Much easier... ask your partners (endpoints) MQ admin for them... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| yaakovd |
| Posted: Fri Sep 12, 2008 8:35 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
you can use Unicode 1208 for output.
Your mainframe propably have:
Encoding = 273
CodedCharSetId = 424
But question if you need somebody to read the data from your attachment. Simple ASBITSTREAM function conversion will not convert numeric values - you only will see converted string fields.
Much better to use Message set (you can create it directly from copy-book).
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Sep 12, 2008 9:59 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| yaakovd wrote: |
you can use Unicode 1208 for output.
Your mainframe propably have:
Encoding = 273
CodedCharSetId = 424
But question if you need somebody to read the data from your attachment. Simple ASBITSTREAM function conversion will not convert numeric values - you only will see converted string fields.
Much better to use Message set (you can create it directly from copy-book).
|
Yaakov, you mean to say that Venkata is using HEBREW EBCDIC ??
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| yaakovd |
| Posted: Fri Sep 12, 2008 11:31 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
no really 
it can be 500, 037, 273, 277, 278, 280, 284, 285, 297, 871, 1047...
but my point was about loosing unreadable data - especially numeric.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
| mqjeff |
| Posted: Sun Sep 14, 2008 10:16 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| fjb_saper wrote: |
| Yaakov, you mean to say that Venkata is using HEBREW EBCDIC ?? |
I thought EBCDIC was bad enough. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Sep 14, 2008 10:17 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| mqjeff wrote: |
| fjb_saper wrote: |
| Yaakov, you mean to say that Venkata is using HEBREW EBCDIC ?? |
I thought EBCDIC was bad enough. |
It comes in all flavors, even URDU. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| yaakovd |
| Posted: Sun Sep 14, 2008 11:24 am Post subject: |
|
|
Partisan
Joined: 20 Jan 2003
Posts: 319
Location: Israel
|
| fjb_saper wrote: |
| It comes in all flavors, even URDU. |
what about Sanskrit and Hindi
Anyway it much easy to check with source system... they should know.
_________________
Best regards.
Yaakov
SWG, IBM Commerce, Israel |
|
| Back to top |
|
|
|
|
