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 |
|
![](templates/DAJ_Glass/images/spacer.gif) |
Vitor |
Posted: Fri Apr 21, 2017 5:44 am Post subject: Re: ASCII to EBSDIC conversion using ESQL |
|
|
![](images/avatars/905340816499abc1cdfb07.jpg) 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 |
|
![](templates/DAJ_Glass/images/spacer.gif) |
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 |
|
![](templates/DAJ_Glass/images/spacer.gif) |
Vitor |
Posted: Fri Apr 21, 2017 6:50 am Post subject: |
|
|
![](images/avatars/905340816499abc1cdfb07.jpg) 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 |
|
![](templates/DAJ_Glass/images/spacer.gif) |
fjb_saper |
Posted: Fri Apr 21, 2017 10:41 am Post subject: |
|
|
![](images/avatars/gallery/misc/2.gif) Grand High Poobah
Joined: 18 Nov 2003 Posts: 20697 Location: LI,NY
|
And remember you have at a minimum to CAST to CHAR for the conversion to happen. A BLOB gets never converted! ![](images/smiles/innocent.gif) _________________ MQ & Broker admin |
|
Back to top |
|
![](templates/DAJ_Glass/images/spacer.gif) |
|