| Author |
Message
|
| rajeshraj |
 Posted: Fri Apr 21, 2017 5:40 am Post subject: ASCII to EBSDIC conversion using ESQL |
 |
|
Newbie
Joined: 21 Apr 2017
Posts: 4
|
Hi,
I tried to convert ASCII message to EBCDIC as below.
Input blob message --> Covert it to charater and saved in environment --> convert to blob output using CCSID 277.
This is working fine for small messages. If I try to use more than 1 MB message nothing is propagated to the output.
Can anyone tell other way of doing the conversion of big files (without saving it in environment and without parsing it)
thanks |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Apr 21, 2017 5:44 am Post subject: Re: ASCII to EBSDIC conversion using ESQL |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rajeshraj wrote: |
| Can anyone tell other way of doing the conversion of big files (without saving it in environment and without parsing it) |
Tell broker (on the FileInput node) it's reading an EBCDIC file. Tell Broker (on the FileOutput node) you want the results in ASCII.
Internally broker uses UTF-16.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rajeshraj |
| Posted: Fri Apr 21, 2017 6:15 am Post subject: |
|
|
Newbie
Joined: 21 Apr 2017
Posts: 4
|
Hi,
Sorry to mention before.
I am using toolkit Version: 8.0.0.5 where I am not able to see the encoding option in the FileOutput node.
thanks |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Apr 21, 2017 6:50 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rajeshraj wrote: |
| I am using toolkit Version: 8.0.0.5 where I am not able to see the encoding option in the FileOutput node. |
My bad. On output the CCISD Property controls what's used for serialization.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Apr 21, 2017 10:41 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
And remember you have at a minimum to CAST to CHAR for the conversion to happen. A BLOB gets never converted! 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
