| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| How to send messages to Data warehouse in message flow? |
« View previous topic :: View next topic » |
| Author |
Message
|
| victor |
 Posted: Tue Apr 29, 2003 12:02 pm Post subject: How to send messages to Data warehouse in message flow? |
 |
|
Newbie
Joined: 29 Apr 2003
Posts: 2
|
Hi all,
Can anyone explain me how to store the messages in datawarehouse .
Do I have to use two colunms in the tables one for timestamp and one for message. And should the message column type be blob .Do I have to use select statements to send the messages to Datawarehouse.If yes, can anyone write a sample sql. I don't have enough knowledge about it. Can any one explain be better.
Thanks,
Victor |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Apr 29, 2003 12:54 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The warehouse node is documented fairly extensively in the Help available from within the Control Center. It explains how to set up the node.
But the warehouse node does not seem very useful to me, particularly in it's default configuration.
I found it more useful to create my own table to suit my own needs for storage and recovery, and create ESQL to populate this table like any other table. |
|
| Back to top |
|
|
| victor |
| Posted: Tue Apr 29, 2003 12:59 pm Post subject: |
|
|
Newbie
Joined: 29 Apr 2003
Posts: 2
|
JeffLowrey,
Thanks for the reply. I have gone through control center document and I didn't get much info. Management wants to store the messages to Warehouse only. So I want to send the messages to warehouse.I don't need to retrive the messages. So can you help sending the messages to Warehouse.
Thanks,
Victor |
|
| Back to top |
|
|
| michaelpatton |
| Posted: Fri May 09, 2003 7:43 am Post subject: |
|
|
Apprentice
Joined: 21 May 2002
Posts: 25
Location: East Coast USA
|
You will need two columns in the warehouse table on your database. It does not matter what you call them. What matters is that you set the TIMESTAMP column to be of type VARCHAR (20) and the MESSAGE column to be a BLOB. Make the BLOB column sufficiently large for whatever messages you are going to store in it.
Thats all there is to it. |
|
| 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
|
|
|
|
