MQSeries.net :: View topic - Can I use a reference variable in a WHERE clause ?

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 » Can I use a reference variable in a WHERE clause ?

Can I use a reference variable in a WHERE clause ?

« View previous topic :: View next topic »

Author

Message

CHERIANV

Posted: Tue Aug 27, 2002 10:35 am Post subject: Can I use a reference variable in a WHERE clause ?

Apprentice

Joined: 15 Feb 2002
Posts: 43
Location: New York

Hi,
Was wondering if I could use a REFERENCE variable as follows in a WHERE clause in a SELECT query from a table ?

DECLARE VAL_REF REFERENCE TO InputRoot.XML.PARENT.CHILD;

SET Environment.Variables.PARMS[] = (SELECT T1.COL1, T1.COL2 FROM Database.TAbl AS T1 WHERE T1.VALUE = VAL_REF.VALUE);

It somehow doesnt seem to work.

CHERIANV

Posted: Tue Aug 27, 2002 10:41 am Post subject:

Apprentice

Joined: 15 Feb 2002
Posts: 43
Location: New York

Please ignore this post. I just got this working.. Thanks!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Can I use a reference variable in a WHERE clause ?

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