| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Select and other Operations on Environment Variables [ESQL] |
« View previous topic :: View next topic » |
| Author |
Message
|
| arthasdk |
 Posted: Tue Nov 01, 2016 8:43 am Post subject: Select and other Operations on Environment Variables [ESQL] |
 |
|
Newbie
Joined: 04 Aug 2016
Posts: 3
|
Hi Guys,
I have the result of 2 queries stored in two variables like :
SET Environment.Variables.Var1[] = SELECT col1,col2... from Table1... where .....;
SET Environment.Variables.Var2[] = SELECT col1,col2... from Table2... where .....;
Now, I have to do a inner join between Var1 and Var2, using something like below:
SET Environment.Variables.Var1[] = SELECT A.*, B.* FROM
Environment.Variables.Var1[] AS A, Environment.Variables.Var2[] AS B
WHERE A.col1 = B.col1;
This is throwing me an error at run time, please advice whether something like this is remotely possible, thanks !
Note1 : The queries for Var1/Var2 aren't so simple and I have also added stuff to the variables after the select...
Thanks !! |
|
| Back to top |
|
 |
| timber |
| Posted: Wed Nov 02, 2016 1:14 pm Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1292
|
It definitely should be possible; most things are possible with a SELECT statement if you try hard enough 
I would advise you to simplify the SELECT statement until it works, then progressively add back the stuff that you took out until it breaks. At that point, *carefully* read the error messages that you get (make sure to take a user trace so that you get the entire text of the runtime messages) and see if you can work out what the problem is.
Feel free to post again (with full text of any errors) if you get stuck. |
|
| 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
|
|
|
|
