MQSeries.net :: View topic - How to perform a SET on a ESQL array type?

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 » How to perform a SET on a ESQL array type?

How to perform a SET on a ESQL array type?

« View previous topic :: View next topic »

Author

Message

NiceGuy

Posted: Fri Jun 11, 2010 11:27 am Post subject: How to perform a SET on a ESQL array type?

Apprentice

Joined: 11 Jun 2009
Posts: 37

Question:

If I copy an array into a ROW

For example:

Code:

Declare temp ROW;
SET temp = InputRoot.MRM.Invoice[]

How do I syntactically perform an update on the entire array?

Say for example I wanted to perform something similar to ....

Code:

SET T.Id = '12345678' FROM temp.Invoice[] AS T WHERE T.VendorName = 'SomeVendor';

The UPDATE does not appear to work because "UPDATE" I believe is only
for database .. but can a similar operation be applied to an array?
Thanks again

kimbert

Posted: Sat Jun 12, 2010 12:59 pm Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

This question arises from this thread: http://www.mqseries.net/phpBB2/viewtopic.php?t=54002
...but it's a more specific question, and it's useful to have it as a separate thread. The answer might appear on the other thread, though.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to perform a SET on a ESQL array type?

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