MQSeries.net :: View topic - SOAP Response to DB2 Table

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SOAP Response to DB2 Table

SOAP Response to DB2 Table

« View previous topic :: View next topic »

Author

Message

nukalas2010

Posted: Mon May 30, 2011 1:33 am Post subject: SOAP Response to DB2 Table

Master

Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....

I am looking for some suggestions on a particular design we would like to do in a message broker.

In current design we are getting a response from SOAPRequest Node which we are doing some transformations
and sending to the queue.

Quote:

MQInputNode (out) -> compute node (Transformation) (out) -> SOAP Request Node (Out) -> compute node (transformation) -> mqoutputnode

But, now we need to store the xml string of the response of the service and date into DB2 table.

Quote:

MQInputNode (out) -> compute node (Transformation) (out) -> SOAP Request Node (Out) -> compute node (transformation) -> mqoutputnode

SOAP Request Node (out) -> Compute Node(to insert data to DB2 Table)

Here, XML string means which is the soap body(I think so). but it contains various fields with values. BUt we need to store all the data into
one column named "xml_string"...

IS this the best practise of doing so??

Please suggest me If I am wrong...

smdavies99

Posted: Mon May 30, 2011 2:28 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

There have been a number of posts on this very subject here recently.
For instance
http://www.mqseries.net/phpBB2/viewtopic.php?t=57608

However, what is the dayatype of the target column? That will influence what you do.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

nukalas2010

Posted: Mon May 30, 2011 4:27 am Post subject:

Master

Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....

smdavies99 wrote:

However, what is the dayatype of the target column? That will influence what you do.

Yeah thanku davies... As we want to specify the target column as CHARACTER data type... !!!!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SOAP Response to DB2 Table

Jump to:

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

Protected by Anti-Spam ACP