MQSeries.net :: View topic - Need some light on "Workspace in ESQL"

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 » Need some light on "Workspace in ESQL"

Need some light on "Workspace in ESQL"

« View previous topic :: View next topic »

Author

Message

kkiscool

Posted: Fri Jan 18, 2002 2:09 pm Post subject:

Newbie

Joined: 17 Jan 2002
Posts: 1

I query an Oracle DB where I get multiple rows and these are the primary keys of that table. The primary keys need to be captured in some way so that I can use them to query another table with each of these keys. Arrays are not supported in ESQL and my message domain is NEONMSG. Is there a way I can use XML in NEONMSG domain to get these values using WORKSPACE feature if yes then HOW? Thanks in advance ...

kirani

Posted: Fri Jan 18, 2002 3:42 pm Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

You can make use of WKSPACE parser (Supportpac IA0E) to do this. Here is a sample ESQL,

SET OutputRoot.WKSPACE.PrimaryKey[] = (SELECT T.PrimaryKey FROM TABLE AS T);

If you have WMQI 2.1, you can make use of 'Environment' tree.

Good luck!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Need some light on "Workspace in ESQL"

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