| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Help about SELECT query in ESQL |
« View previous topic :: View next topic » |
| Author |
Message
|
| harisomayaji |
 Posted: Wed Mar 26, 2008 9:42 pm Post subject: Help about SELECT query in ESQL |
 |
|
Newbie
Joined: 19 Mar 2007
Posts: 2
|
Hi,
I m new to WMB. In my application i want to write a query to select some fields from database. After selecting those variables i have to assign that fields to some variables, how can i achieve this.
EX :
DECLARE str1 CHARACTER;
DECLARE str2 CHARACTER;
Query : SELECT B FROM Database.SAMPLE_TABLE AS B WHERE B.APPNO = 'APPNO'
Now how can i retrieve the element from query and assighn it to the variables str1 and str2
Thanks in advance,
Hari |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Wed Mar 26, 2008 10:04 pm Post subject: Re: Help about SELECT query in ESQL |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| harisomayaji wrote: |
| I m new to WMB. |
Most Welcome....my suggestion is please go for a training/go through the PDF's first...dont be blank in front of WBIMB (its too vast).
| harisomayaji wrote: |
In my application i want to write a query to select some fields from database. After selecting those variables i have to assign that fields to some variables, how can i achieve this.
EX :
DECLARE str1 CHARACTER;
DECLARE str2 CHARACTER;
Query : SELECT B FROM Database.SAMPLE_TABLE AS B WHERE B.APPNO = 'APPNO' |
Clue
Set <Variable> = Select Query;
If you still sounds this as tough...tougher and toughest.
Open your toolkit and surf, read, and practice (CTRL + TAB) through the below link
http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/ac30240_.htm
Go ahead, We are here to make easy ...easier and easiest
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Mar 26, 2008 10:19 pm Post subject: Re: Help about SELECT query in ESQL |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
| harisomayaji wrote: |
EX :
DECLARE str1 CHARACTER;
DECLARE str2 CHARACTER;
Query : SELECT B FROM Database.SAMPLE_TABLE AS B WHERE B.APPNO = 'APPNO'
Now how can i retrieve the element from query and assighn it to the variables str1 and str2
|
If you want to retrive 2 variables from database, a single assignment wont work..
You need to first create an environment tree element and fetch the data from database to that.... and then u can assign respective values to the variables.....
_________________
Cheers |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
