| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to insert & retreive MQRFH2 data from Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| efei |
 Posted: Thu Feb 27, 2003 1:53 am Post subject: How to insert & retreive MQRFH2 data from Database |
 |
|
Newbie
Joined: 27 Feb 2003
Posts: 2
|
I just read the article "Creating a RFH2 folder from a String".
Now I have similar requirements :
1. The source system send a message with MQRFH2 into WMQI (V2.1).
There are a few variable tags in the MQRFH2.
Ex. <Log><Key1>Value1</Key1><Key2>Value2</Key2></Log>
2. The target system does not support MQRFH2.
So we have to remove MQRFH2, and insert the whole data in the <Log> folder into DB (using ESQL).
3. When WMQI receives the response message from the target system,
we have to retreive the original data from DB, and use it to create the <Log> folder in MQRFH2 (using ESQL).
I have known how to remove MQRFH2, but I have no idea of how to insert & retreive the <Log> folder in MQRFH2.
Your advice will be highly appreciated.
It would be better if there are some samples.
Thanks a lot !!
efei |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Feb 27, 2003 10:27 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
You can create one field for each element in the <Log> folder. You can use simple ESQL code to insert and retrieve data from this 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 |
|
|
| efei |
| Posted: Mon Mar 03, 2003 4:06 am Post subject: |
|
|
Newbie
Joined: 27 Feb 2003
Posts: 2
|
What if there are 100 tags in the <Log> folder ?
What I meant to do is :
1. Convert the whole data in the <Log> folder into bitstream or characters, and then insert into the DB as BLOB.
2. Retreive the BLOB field from the DB, convert into characters and then set into the <Log> folder.
How to implement this using ESQL ? |
|
| 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
|
|
|
|
