| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| about EDI and DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| noblate |
 Posted: Fri Oct 29, 2004 1:38 pm Post subject: about EDI and DB |
 |
|
Apprentice
Joined: 06 Sep 2004
Posts: 27
|
Hi All the QI Gurus,
Has enybody done puting EDI message to database in db related nodes.
how many tales are envolved in one kind of EDI message.
Noblate |
|
| Back to top |
|
 |
| kirani |
| Posted: Fri Oct 29, 2004 2:47 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Can you explain your requirements?
_________________
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 |
|
|
| noblate |
| Posted: Fri Oct 29, 2004 3:22 pm Post subject: |
|
|
Apprentice
Joined: 06 Sep 2004
Posts: 27
|
Thanks for Kiran,
A EDI X12 message was put on a MQ input node, then the message flow take the data from the EDI message and put it in a database.
Noblate |
|
| Back to top |
|
|
| RocknRambo |
| Posted: Fri Oct 29, 2004 6:33 pm Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
EDI Messages r flat files, probably a fixed length file.
WMQI Parser by default handles only xml messages.
Now for you req. u need to Design a Message Set which does the parsing and using a compute or database node..than insert into dB.
-RR |
|
| Back to top |
|
|
| kirani |
| Posted: Sat Oct 30, 2004 12:45 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Well, its upto you how you want to store the data. You can either store the complete incoming message into single field in TEXT format or you can store your message into different DB fields in a particular table.
_________________
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 |
|
|
|
|
|
| |
|
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
|
|
|
|
