| Author |
Message
|
| sagar_edu5 |
 Posted: Tue Feb 01, 2005 12:33 pm Post subject: Tab delimited file parsing in MRM |
 |
|
Newbie
Joined: 11 Dec 2004
Posts: 7
|
Hi All,
I have a requirement for parsing a tab delimited file within MRM. I am using TDS for doing the requirement in WBIMB v5.0.
I dont understand how to mention "TAB" as a delimiter in the message set. Does any of you have a clue to it?
Any help would be appreciated.
Thanks and Regards,
Sagar |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Feb 01, 2005 12:39 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think that TAB is actually <HT>
But I forget my control characters as often as I use them.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| sagar_edu5 |
| Posted: Tue Feb 01, 2005 3:58 pm Post subject: |
|
|
Newbie
Joined: 11 Dec 2004
Posts: 7
|
Hi Jeff,
Is the TDS mnemonic for tab <HT> for Windows XP platform? Does it matter or change based on platforms.
Thanks and Regards,
sagar |
|
| Back to top |
|
|
| Prithvi |
| Posted: Tue Feb 01, 2005 10:39 pm Post subject: |
|
|
Apprentice
Joined: 20 Dec 2004
Posts: 34
|
As far as i know the ASCII character set is platform independent.
You could go through them at this site:
http://www.finseth.com/parts/ascii.html
Regards
_________________
Prithvi |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Feb 02, 2005 12:03 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
TDS mnemonics are specific to MRM, so they are platform independent.
_________________
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 |
|
|
| sagar_edu5 |
| Posted: Wed Feb 02, 2005 7:32 am Post subject: |
|
|
Newbie
Joined: 11 Dec 2004
Posts: 7
|
Hi,
I have tried parsing the flat file with tab delimited data using TDS(MRM) in WBIMB V5.0
The data is something like this
2 30000 200000 XXXXX
4 13123 123213 YYYYYY
All elements delimited by tab(<HT>) and carriage return(OD OA) after every line.
I have defined the various elements in TDS and created the message set according to the specifications. The problem when i tried parsing is that the message is giving an exception.
Message Translation Interface Parsing Errors have
occurred:
The TDS worker is not receiving a proper Message Id parameter during initialization.
Ensure that the message identifier used in your message matches the message as defined in the Message Brokers Toolkit.
The thing is i have mentioned the message set properties in the MQInput node. I have followed some earlier posts but i couldnt get a clue. Is it possible that TDS is unable to parse this tab delimited flat file?
Any suggestions would be accepted. Is there any experience parsing tab delimited flat files?
Thanks and Regards,
sagar |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 02, 2005 7:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you deploy the message set along with the message flow?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| shanson |
| Posted: Wed Feb 02, 2005 8:20 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
This error occurs before the message is parsed, so it is nothing to do with tabs (and <HT> is the correct mnemonic btw, and it only gets applied after data conversion to unicode has occurred so there are no platform issues).
As stated above check that the Message Domain, Message Set, Message Type and Message Format properties all match your message, and that the message set in the deployed bar file was generated after the message was added. The Message Type should be the message name as shown in the V5 toolkit message editor. |
|
| Back to top |
|
|
| sagar_edu5 |
| Posted: Wed Feb 02, 2005 10:05 am Post subject: |
|
|
Newbie
Joined: 11 Dec 2004
Posts: 7
|
Hi Hanson,
I checked that the Message Domain, Message Set, Message Type and Message Format properties are all matching in the flow but i am still getting the same error. I am giving the input message with the tab delimited through RFHUtil.
Thanks and regards,
sagar |
|
| Back to top |
|
|
| shanson |
| Posted: Wed Feb 02, 2005 10:25 am Post subject: |
|
|
Partisan
Joined: 17 Oct 2003
Posts: 344
Location: IBM Hursley
|
| Has the MQRFH2 got the correct mcd folder information - this overrides the domain/set/type/format info on the input node? |
|
| Back to top |
|
|
| sagar_edu5 |
| Posted: Wed Feb 02, 2005 10:38 am Post subject: |
|
|
Newbie
Joined: 11 Dec 2004
Posts: 7
|
Where can i get this mcd folder info?
thanks,
sagar |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 02, 2005 10:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| sagar_edu5 wrote: |
Where can i get this mcd folder info?
thanks,
sagar |
Since you are using RFHUtil to create the MQRFH2 header, then you should set these properties in the correct pane on the RFHUtil, so it will build them properly into the message.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
