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 » Search

 Search found 3 matches
Author Message
  Topic: doubt on select query
veera_satya

Replies: 5
Views: 3032
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Jun 16, 2010 7:58 pm   Subject: doubt on select query
for single value:

It is working for getting single value
Set localVar = THE(select ITEM S1.SCFCODE from Environment.Data.SCF_TABLE[] as S1
where S1.Feild1='CBS');

For retrieving whole row: ...
  Topic: doubt on select query
veera_satya

Replies: 5
Views: 3032
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Jun 16, 2010 6:22 pm   Subject: doubt on select query
Any suggessions please. I am able to retrieve single value from entire row.
Set localVar = select ITEM S1.SCFCODE from Environment.Data.SCF_TABLE[] as S1
where S1.Feild1='CBS';

Because this is ...
  Topic: doubt on select query
veera_satya

Replies: 5
Views: 3032
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Jun 16, 2010 5:47 pm   Subject: doubt on select query
HI All,

I need a small favour in esql coding.

I have a scenario to get the entire row from Environment selectively and store in a local varibale. I need to use this variable till this esql ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


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

Copyright © MQSeries.net. All rights reserved.