MQSeries.net :: View topic - inserting data into DB

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 » inserting data into DB

Goto page Previous 1, 2

inserting data into DB

« View previous topic :: View next topic »

Author

Message

smdavies99

Posted: Mon Jan 09, 2012 3:05 am Post subject:

Jedi Council

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

indu30111986 wrote:

Version is 7.0

Version of what is 7.0? WMQ or WMB or Both?
Have you applied any fixpacks?
_________________
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.

indu30111986

Posted: Mon Jan 09, 2012 4:27 am Post subject:

Novice

Joined: 15 Nov 2011
Posts: 22

No fix packs are applied..

The version of boh WMB and WMQ is 7.0

The select statement is working absolutely fine.

SET OutputRoot.XML.Test.Result[] = (SELECT T.* FROM Database.Indu.TABLE1 AS T);

the output xml is

<Test>
<Result>
<ID>1</ID>
<NAME>indu</NAME>
<ROLE>Developer</ROLE>
</Result>
<Result>
<ID>2</ID>
<NAME>amir</NAME>
<ROLE>Developer</ROLE>
</Result>
<Result>
<ID>3</ID>
<NAME>thila</NAME>
<ROLE>Developer</ROLE>
</Result>
</Test>

Only insert and update statements are not working.

DECLARE msgID REFERENCE TO InputRoot.XMLNSC.Test.Result.Column1;
DECLARE msgName REFERENCE TO InputRoot.XMLNSC.Test.Result.Column2;
INSERT INTO Database.TABLE1(ID,NAME,ROLE) VALUES ('4','AAA','Tester');
UPDATE Database.Indu.TABLE1 AS T SET ID = msgID WHERE T.NAME = msgName;

The input xml would be

<Test>
<Result>
<Column1>4</Column1>
<Column2>thila</Column2>
</Result>
</Test>

kimbert

Posted: Mon Jan 09, 2012 5:16 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Quote:

The select statement is working absolutely fine.

SET OutputRoot.XML.Test.Result[] = (SELECT T.* FROM Database.Indu.TABLE1 AS T);

...but that line of ESQL is badly broken. Why are you assigning to OutputRoot.XML and not OutputRoot.XMLNSC?

Display posts from previous:

Goto page Previous 1, 2

Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » inserting data into DB

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