MQSeries.net :: View topic - Problem read resultset after Migration from WMQI 2.1 to 5.0

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem read resultset after Migration from WMQI 2.1 to 5.0

Problem read resultset after Migration from WMQI 2.1 to 5.0

« View previous topic :: View next topic »

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

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?

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

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

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

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Problem read resultset after Migration from WMQI 2.1 to 5.0

Jump to:

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

Protected by Anti-Spam ACP