| Author |
Message
|
| RichA |
 Posted: Mon May 19, 2003 1:04 am Post subject: Combine XML Message problem |
 |
|
Centurion
Joined: 14 Mar 2002
Posts: 102
|
I'm trying to combine 3 XML request messages, originally I tried using aggregate node, but that combines reply messages. The messages all get put to one input node, filtered to different flows where they are validated, then the whole message is put to a CLOB field in a database table with a correlation ID to match up the ones to combine. When the 3 different messages are available in the database I use a compute node to combine them, into a single XML message format similar to -
<MSG>
<MSG1>blahblahblah</MSG1>
<MSG2>blahblahblah</MSG2>
<MSG3>blahblahblah</MSG3>
</MSG>
the information in each of the messages in the database appears as it was originally, with the <> tags being present, after the compute node puts the messsage together the format is changed to < > etc. I have tried to then put the message through a reset content descriptor node, but it doesn't change the message. Any ideas? |
|
| Back to top |
|
 |
| shalabh1976 |
| Posted: Mon May 19, 2003 8:14 am Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Suppose you extract the message from the database into a BLOB field msgblob then you can use :
CREATE LASTCHILD of OutputRoot DOMAIN 'XML' PARSE (msgblob,546,437);
546 and 437 are optional clauses for Encoding and CCSID. |
|
| Back to top |
|
|
| RichA |
| Posted: Mon May 19, 2003 12:10 pm Post subject: |
|
|
Centurion
Joined: 14 Mar 2002
Posts: 102
|
Ah, that's great. Thanks for that. 
I'm thinking my problems are being caused by a lack of ESQL  , can anyone recommend some learning/reading material? |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Mon May 19, 2003 12:19 pm Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Lot of documentation is actually available.
Accessability will depend on the platform you are on.
For NT it is:
Start-->Programs-->IBM Websphere MQ Integrator 2.1-->Documentation-->All manuals-->Library-->ESQL Reference
I don't know about the other platforms but a search in the IBM website should help. |
|
| Back to top |
|
|
| RichA |
| Posted: Mon May 19, 2003 12:48 pm Post subject: |
|
|
Centurion
Joined: 14 Mar 2002
Posts: 102
|
| I wouldn't have thought to look at the CREATE command to parse an object to be honest though. I was maybe wanting a guide rather than just a command reference, after all I could read through a lot of commands without ever finding the one I want. It's kind of like giving someone a dictionary and expecting them to learn to read. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 19, 2003 12:49 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Actually, odds are extremely good that any documentation that exists in your install directory is out of date.
You're much better off getting the ESQL Reference from http://www-3.ibm.com/software/integration/library/manualsa/.
You'll also want the CSD Release Guide documenting changes since CSD03 if you're using CSD03 or later. AND you should also read your readmes from your install directory - particularly if you're using CSD04, since there's stuff in there that's not documented elsewhere. |
|
| Back to top |
|
|
|
|
