| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WBI 4.2 WHERE IN problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| helldoggie |
 Posted: Fri Apr 20, 2007 6:04 am Post subject: WBI 4.2 WHERE IN problem |
 |
|
Newbie
Joined: 07 Sep 2006
Posts: 6
|
Hi,
I'm using WBI system manager version 4.2.2. and I need to build a business object for selecting data out of a database. It should look something like this.
select * from ... where status in (status1,status2,...,statusN)
Seems when i hardcoded the values in the field like this:
select ... from ... where status in ('OPEN','CLOSED','IN PROGRESS')
,it works fine.
Cause the number of parameters and also the parameters itself are variable, I tried to fill in the general options from the BO at the retrieve clause: STATUS_CODE IN(@):..STATUS
I figured out that the WBI always put quotes around the statements, so the selection wont' work.
So doing something like: STATUS_CODE IN (@,@,@,@,@,@,@,@,@,@,@,@,@,@,@):..STATUS1,..STATUS2 and so on
Now i'm wondering if there is no other solution for this problem.
If anyone has some info about this, it's always welcome  .
Thx
Tim |
|
| Back to top |
|
 |
| mgk |
| Posted: Fri Apr 20, 2007 6:19 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
Try looking at the PASSTHRU statement, as this allows you to dynamically construct your DB statement.
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| 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
|
|
|
|
