| Author |
Message
|
| yonny |
 Posted: Thu Dec 16, 2004 12:59 pm Post subject: XML to TDS |
 |
|
Apprentice
Joined: 08 Jul 2001
Posts: 49
Location: Santo Domingo
|
Hi, I want to know if there is any document/tutorial to learn a simple way to transform this:
<?xml version="1.0"?>
<MESSAGE TYPE="RQ">
<SERVICESOURCE>PSOFT</SERVICESOURCE>
<FUNCTION>PAY</FUNCTION>
<ACCOUNTFROM>9999999</ACCOUNTFROM>
<ACCOUNTTYPEFROM>CHECKING</ACCOUNTTYPEFROM>
<AMOUNTFROM>2500</AMOUNTFROM>
<CURRENCYFROM>DOP</CURRENCYFROM>
<DESCRIPTIONFROM>NULL</DESCRIPTIONFROM>
<ACCOUNTTO>NULL</ACCOUNTTO>
<ACCOUNTTYPETO>NULL</ACCOUNTTYPETO>
<AMOUNTTO>NULL</AMOUNTTO>
<CURRENCYTO>NULL</CURRENCYTO>
<DESCRIPTIONTO>NULL</DESCRIPTIONTO>
<TIPOBENEF>1</TIPOBENEF>
<REFERENCE>999</REFERENCE>
<DATE>20041214</DATE>
<TIME>120000</TIME>
</MESSAGE>
Into something like this:
RQ|PAY|9999999|CHECKING|2500|DOP|1|999|20041214|120000|
Please notice:
- when an XML element is "empty" the "NULL" string is used.
- the delimiter used in the TDS message is the pipe symbol '|'.
Right now I am parsing the XML using a message set, but I am stuck with the output message: should I use ESQL or mappings. and how?
Thank you for your help.
Yonny |
|
| Back to top |
|
 |
| vennela |
| Posted: Thu Dec 16, 2004 2:14 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
|
| Back to top |
|
|
| kirani |
| Posted: Thu Dec 16, 2004 11:23 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
You can do this either way. Please take a look at the link on the top of this page, you will find some very good redbooks and WBIMB manuals.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| yonny |
| Posted: Sun Dec 19, 2004 4:25 pm Post subject: |
|
|
Apprentice
Joined: 08 Jul 2001
Posts: 49
Location: Santo Domingo
|
Thank you Venella and Kirani, I downloaded the redbooks and manuals suggested by you, but did not advance too much. I am new to the Broker Toolkit software and have not worked with the ESQL language (although I had some experience with other programming languages).
Could be possible for you to point me to a more specific example, like a simple ESQL code?
Just to get me started. Thanks in advance. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sun Dec 19, 2004 4:36 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Maybe you should consider paying someone for some training.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| JT |
| Posted: Mon Dec 20, 2004 7:23 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| Could be possible for you to point me to a more specific example, like a simple ESQL code? |
Examples are available throughout the Help facility. Click here for ESQL details. |
|
| Back to top |
|
|
| yonny |
| Posted: Mon Dec 27, 2004 12:07 pm Post subject: |
|
|
Apprentice
Joined: 08 Jul 2001
Posts: 49
Location: Santo Domingo
|
| Quote: |
| Maybe you should consider paying someone for some training. |
Capitalism eh !
Problem solved, thanks. |
|
| Back to top |
|
|
|
|
