|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
OutputFormat in ESQL code |
« View previous topic :: View next topic » |
Author |
Message
|
IntegratorWMB |
Posted: Wed Oct 29, 2008 7:44 am Post subject: OutputFormat in ESQL code |
|
|
Apprentice
Joined: 06 Dec 2007 Posts: 27
|
Currently I have a flow which takes an EDI and Converts to a properitary TDF format. I had defined the message sets and it is working.
Note: To keep it simple I am not going in to the record structure.
TDF Output Format:
TAG1;Record1
TAG2;Record2
...
TAGN;RecordN
One of the clients wants the output as an xml. Basically the xml is to carry an APP ID which comes as part of the incoming EDI message. So the output XML is going to look like
<ApplicationID>INV</ApplicationID>
<ClientID>clientName</ClientID>
<Message>
TAG1;Record1
TAG2;Record2
...
TAGN;RecordN
</Message>
Currently my main flow (I am leaving the error /failure scenario)
MQInput --> Compute --> MQOutput
Since this xml is only for one client I just dont want to create a separate flow., rather I thought of modifying the existing flow to support both TDF and XML output. In such a scenario, how can I embed the TDF output in my XML output.
Thanks |
|
Back to top |
|
 |
Gaya3 |
Posted: Wed Oct 29, 2008 7:25 pm Post subject: Re: OutputFormat in ESQL code |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
IntegratorWMB wrote: |
Since this xml is only for one client I just dont want to create a separate flow., rather I thought of modifying the existing flow to support both TDF and XML output. In such a scenario, how can I embed the TDF output in my XML output.
|
You can Cast the TDF as BLOB/Character and attach to the XML Element _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Oct 30, 2008 2:09 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
I'm sure you meant "ASBITSTREAM" and not "CAST". |
|
Back to top |
|
 |
Gaya3 |
Posted: Thu Oct 30, 2008 2:31 am Post subject: |
|
|
 Jedi
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
|
mqjeff wrote: |
I'm sure you meant "ASBITSTREAM" and not "CAST". |
exactly, thanks jeff, I meant "ASBITSTREAM". _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
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
|
|
|
|