ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SELECT

Post new topic  Reply to topic
 SELECT « View previous topic :: View next topic » 
Author Message
LisaP
PostPosted: Thu Nov 06, 2003 7:11 am    Post subject: SELECT Reply with quote

Newbie

Joined: 05 Aug 2003
Posts: 4
I was wondering whether anyone could help me with the following question - are there any issues (performance related or otherwise) with using SELECT to set a number of output fields (not to do any database lookup) as opposed to just using SET to set a variable/constant/input field to an output field i.e.

SET <ParentSegment> = THE(SELECT A."<InputField1>" AS "OutputField1", "<Variable1>" AS "OutputField2>, etc FROM <InputMessage> AS A);

Is it preferable to do it this way as opposed to having lines of separate SET statements? Many thanks in advance for you help with this!
Lisa
Back to top
View user's profile Send private message
drajib
PostPosted: Fri Nov 07, 2003 1:51 am    Post subject: Reply with quote

Apprentice

Joined: 25 Mar 2003
Posts: 42
Location: India
Hi Lisa,

Please refer to http://eb2a.test.austin.ibm.com/team/TEPI/Pubs/MQIntegratorV2.1/ESQLRef-bipyae02.pdf
Chapter 8. Using the SELECT function (page 121) states the approach as more concise, it executes faster and the expressions in the clause could be of any complexity with no special restriction ...

Hope this helps!

Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SELECT
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.