| Author |
Message
|
| psn |
 Posted: Tue Apr 19, 2005 3:35 am Post subject: Problem read resultset after Migration from WMQI 2.1 to 5.0 |
 |
|
Disciple
Joined: 30 Oct 2002
Posts: 193
Location: France
|
I have migrate a flow from wmqi 2.1 to wbimb 5.0 with the follow ESQL and in wbimb 5.0 the result variable is empty:
SET Environment.Variables.RAIQ.Result='';
SET Environment.Variables.RAIQ.Result=
the(select T.* from Database.TIP_REQUEST as T WHERE T.REQ_MSG_ID=REQ_MSG_ID);
any ideas !!!???
PSN |
|
| Back to top |
|
 |
| Pete |
| Posted: Tue Apr 19, 2005 4:01 am Post subject: |
|
|
Apprentice
Joined: 25 Nov 2003
Posts: 43
|
Are you sure the database call returns data?
Have you tried executing the select from a command line processor? |
|
| Back to top |
|
|
| psn |
| Posted: Tue Apr 19, 2005 5:24 am Post subject: |
|
|
Disciple
Joined: 30 Oct 2002
Posts: 193
Location: France
|
Yes I am sure when I try the same ESQL with the same input Message with
SELECT T.Field1,T.Field2 ...
it work fine !!!!!
PSN |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Apr 19, 2005 9:45 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
What version of CSD level do you have installed on your server? There was a problem with select statement in the old CSD.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| psn |
| Posted: Tue Apr 19, 2005 11:23 pm Post subject: |
|
|
Disciple
Joined: 30 Oct 2002
Posts: 193
Location: France
|
we have install CSD4 on ZOS
PSN |
|
| Back to top |
|
|
|
|
