| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| message flow design question |
« View previous topic :: View next topic » |
| Author |
Message
|
| k.srinivas |
 Posted: Thu Apr 29, 2004 7:42 am Post subject: message flow design question |
 |
|
Apprentice
Joined: 16 May 2002
Posts: 29
Location: chennai
|
hi guys
plz advice me
i have an incomming xml message.i need to store the entire xml message is a column of a table.iam using oracle 9.oracle 9i supports xml datatype
i need to store the entire xml in a single column
plz advice me what is the node i have to use
thanks srinivas |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Apr 29, 2004 7:53 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Well, you could use any of the following nodes. - Database
- DataInsert
- Warehouse
- Compute
- Custom
Please read the manuals.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| klabran |
| Posted: Thu Apr 29, 2004 7:55 am Post subject: |
|
|
Master
Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ
|
Is your input node parser defined as MRM or XML?
If it XML then you will have to use a compute node.
Here's a sample of what I did...
SET OutputRoot = InputRoot;
-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.
DECLARE INMSG CHAR;
DECLARE HBLOB BLOB;
SET INMSG = cast(asbitstream(OutputRoot.XML,,437) as CHAR CCSID 437);
SET HBLOB = cast(asbitstream(OutputRoot.MQMD) as BLOB);
PASSTHRU('insert into tblBookingsInAudit (sMsgHeader,sdata) values(?,?)',HBLOB,INMSG);
If it is MRM then you could use the Database or warehouse nodes....
I am using SQL Server so the insert syntax may be slightly different. 
|
|
| 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
|
|
|
|
