| Author |
Message
|
| Vitor |
 Posted: Tue Feb 17, 2009 1:10 am Post subject: |
 |
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fjb_saper wrote: |
| Don't know what it would be on an EBCDIC platform... |
Typically (but not always) X'0D'
_________________
Honesty is the best policy.
Insanity is the best defence.
Last edited by Vitor on Tue Feb 17, 2009 3:01 am; edited 1 time in total |
|
| Back to top |
|
 |
| rohank84 |
| Posted: Tue Feb 17, 2009 2:59 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| so wht could be the way to do it ...... |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 17, 2009 3:04 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| so wht could be the way to do it ...... |
You've already been given advice on how to achieve this. By not using BLOB. You, or your site, have chosen not to do this. One consequence of this is that message parsing becomes a lot harder, as you've discovered. I recommend you go back to whoever made this bizzare decision and ask for his advice.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rohank84 |
| Posted: Tue Feb 17, 2009 3:11 am Post subject: |
|
|
Centurion
Joined: 31 Dec 2008
Posts: 109
|
| you mean to say there is no other option to do it without changing the domain.... |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Feb 17, 2009 3:15 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| rohank84 wrote: |
| you mean to say there is no other option to do it without changing the domain.... |
I never say never. I once saw a government project that worked.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Tue Feb 17, 2009 6:12 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| fjb_saper wrote: |
| rohank84 wrote: |
hi guys i solved it ...X'0d0a' is the code for enter key ...used substring to get the string ....
thanks |
Bad practice. You should use the mnemonics.
What happens when you are not on a windows platform? |
The TDS message editor uses mnemonics to represent characters; is there something comparable in ESQL for representing bytes?
Taking the BLOB domain requirement at face value, using X'0d0a' with ESQL string manipulation functions is among the few options available.
Though this does introduce a new subflow requirement: records in the input message BLOB must now be delimited by the byte sequence X'0d0a', regardless of originating platform or character set. |
|
| Back to top |
|
|
|
|
