MQSeries.net :: View topic - Not able to view db table in Database insert node mapping

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 » Not able to view db table in Database insert node mapping

Not able to view db table in Database insert node mapping

« View previous topic :: View next topic »

Author

Message

codered

Posted: Sun Apr 13, 2014 5:09 pm Post subject: Not able to view db table in Database insert node mapping

Novice

Joined: 09 Feb 2014
Posts: 13

Hi,

I am testing Database nodes for my understanding. I have created a small message flow. MQInput ---> Compute--->DatabaseInsert

input is XML Message and using XMLNSC parser and compute node simply copies the incoming XML Message.

I have an input message set to validate the incoming message and created a table in db2 database.

When I want to insert message into table, during the mapping, I can't see the data objects Items at target pane. How does this works? I can I see the tables created in my Db2 db appear in Toolkit?

[/img]

Tibor

Posted: Mon Apr 14, 2014 1:50 am Post subject:

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

Recommended section in Infocenter: Create database definitions

http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/topic/com.ibm.etools.mft.doc/ar37660_.htm

mqsiuser

Posted: Mon Apr 14, 2014 2:38 am Post subject:

Yatiri

Joined: 15 Apr 2008
Posts: 637
Location: Germany

Tibor wrote:

Create database definitions

Do what ever fits your needs. Be aware of the options you have:

You can just insert with an ESQL Compute Node

Within the Compute Node you can use the SQL's native commands within a "PASSTHRU"

Or ESQL's "SELECT" and "INSERT"

I usually use ESQL and PASSTHRU

If not I'd use ESQL and it's functions

The mapping node (esp. together with "table definitions") would be my last resort
_________________
Just use REFERENCEs

Tibor

Posted: Mon Apr 14, 2014 2:45 am Post subject:

Grand Master

Joined: 20 May 2001
Posts: 1033
Location: Hungary

mqsiuser wrote:

The mapping node (esp. together with "table definitions") would be my last resort

Of course yes, because you are an experienced WMB guy. But table definitions can be useful for ESQL as well.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Not able to view db table in Database insert node mapping

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