| Author |
Message |
 Topic: Coverting CLOB data to XML |
satnam
Replies: 4
Views: 3362
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 31, 2003 12:33 pm Subject: Coverting CLOB data to XML |
| Thanks It worked |
| Topic: Coverting CLOB data to XML |
satnam
Replies: 4
Views: 3362
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 31, 2003 8:04 am Subject: Coverting CLOB data to XML |
MY DB field is defined as CLOB ? Can't use BLOB as it's too small.
When I use:
SET OutputRoot."BLOB"."BLOB" = CAST(THE (SELECT ITEM (M.XMLDATA) FROM Database.ISESUSPENSE AS M WHERE M.RECORDTYPE ... |
| Topic: Coverting CLOB data to XML |
satnam
Replies: 4
Views: 3362
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 31, 2003 7:04 am Subject: Coverting CLOB data to XML |
I am trying to Save XML data as CLOB in Database and later trying to retrieve CLOB and convert it back to XML
I am able to Save the XML as CLOb successfully using following Code
SAVE THE MES ... |
| Topic: Storing XML as CLOB |
satnam
Replies: 2
Views: 2534
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 14, 2003 10:40 am Subject: Storing XML as CLOB |
Thanks for the recommendation .I tried using ASBITSTREAM and casting the result of ASBITSTREAM into a CHARACTER but I get the same results
Thanks |
| Topic: Storing XML as CLOB |
satnam
Replies: 2
Views: 2534
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Nov 14, 2003 9:31 am Subject: Storing XML as CLOB |
Hi
I am tring to execute the following statement in WMQI database node
PASSTHRU('INSERT INTO STORAGE(
ID,XML)
VALUES (?,?)' , id ,BITSTREAM("Body"));
here is my table definition
... |
| Topic: MRM Parser Vs XML parser |
satnam
Replies: 2
Views: 2531
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 21, 2003 8:21 am Subject: MRM Parser Vs XML parser |
The INPUT message is not causing the problem and also I am not validating the INPUT XML
The problem is with the output message defined as message set where my root element(I have this compound type a ... |
| Topic: MRM Parser Vs XML parser |
satnam
Replies: 2
Views: 2531
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 20, 2003 7:28 am Subject: MRM Parser Vs XML parser |
I am building a Process flow where the output message is created with XML defined in Message set,
If I use a MRM Parser setting in runtime the process works fine but if I set XML parser in Runtime t ... |
