| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Making DB Query with arrays |
« View previous topic :: View next topic » |
| Author |
Message
|
| Mandrake90 |
 Posted: Mon Oct 26, 2020 4:27 am Post subject: Making DB Query with arrays |
 |
|
Novice
Joined: 11 Feb 2020
Posts: 10
|
Hi All,
I have a LOV in my esql code, named Environment.ListofIDs[]
How can I put it into a WHERE condition whithin a DB query?
Like this
qryRes= SELECT COUNT(*) where Database.DBTTABLE as DBT where DBT.ID in (Environment.ListofIDs[])
Have I to write a cycle on the array to make several queries and then sum the results?
thanks!! |
|
| Back to top |
|
 |
| exerk |
| Posted: Mon Oct 26, 2020 5:16 am Post subject: |
|
|
Jedi Council
Joined: 02 Nov 2006
Posts: 6339
|
You might be better off posting this question in a DB forum - MQ is not a DB.
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys. |
|
| Back to top |
|
|
| Mandrake90 |
| Posted: Mon Oct 26, 2020 8:35 am Post subject: |
|
|
Novice
Joined: 11 Feb 2020
Posts: 10
|
thanks but in SQL the query works because it is quite simple.
SELECT COUNT(*) FROMT DBTABLE where ID in (1,2,3,4,5)
the issue is on Esql because I cannot put my array in the WHERE condition
 |
|
| 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
|
|
|
|
