ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBIMB 5.0 Database Select with database MIN() function

Post new topic  Reply to topic
 WBIMB 5.0 Database Select with database MIN() function « View previous topic :: View next topic » 
Author Message
tdwells
PostPosted: Fri Dec 03, 2004 10:34 am    Post subject: WBIMB 5.0 Database Select with database MIN() function Reply with quote

Apprentice

Joined: 30 Oct 2002
Posts: 42
Can anyone tell me what is wrong with below esql statement. We are running WBIMB 5.0 CSD04
The esql is:


SET strCorrelId = THE (SELECT ITEM a.PARM1_TXT
FROM Database.adbfTable AS a
WHERE a.maint_by_uid = (select
MIN(b.maint_by_uid) from Database.adbftable AS b));

I am getting the following error in my exception lists:

(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRd
lDatabaseSelect.cpp'
(0x03000000):Line = 116
(0x03000000):Function = 'SqlDatabaseSelectBase::dispatch'
(0x03000000):Type = 'ComIbmDatabaseNode'
(0x03000000):Name = 'DEV_VFC_WMQI_RATEWARE_2_2#FCMComposite_1_25'
(0x03000000):Label = 'DEV_VFC_WMQI_RATEWARE_2_2.VFC_RATEWARE_MAINT_Da
tabase2'
(0x03000000):Text = 'implementation error'
(0x03000000):Catalog = 'BIPv500'
(0x03000000):Severity = 3
(0x03000000):Number = 2110
)
_________________
IBM Certified Specialist - MQSeries
Back to top
View user's profile Send private message
tdwells
PostPosted: Fri Dec 03, 2004 12:38 pm    Post subject: Reply with quote

Apprentice

Joined: 30 Oct 2002
Posts: 42
FYI. I managed to get this to work by changing my esql to:

SET Environment.Data[] = PASSTHRU ('SELECT a.PARM1_TXT
FROM VFAI.INTG_PARMS_DTL AS a WHERE a.maint_by_uid = (select MIN(b.maint_by_uid) from VFAI.INTG_PARMS_DTL AS b)
');

If anyone has any input on negative performance issues using PASSTHRU, please let me know.

Troy
_________________
IBM Certified Specialist - MQSeries
Back to top
View user's profile Send private message
tdwells
PostPosted: Fri Dec 03, 2004 1:31 pm    Post subject: Reply with quote

Apprentice

Joined: 30 Oct 2002
Posts: 42
For consistency with my original posts, my changed esql is:

SET Environment.Data[] = PASSTHRU ('SELECT a.PARM1_TXT
FROM adbfTable AS a WHERE a.maint_by_uid = (select MIN(b.maint_by_uid) from adbfTable AS b)
_________________
IBM Certified Specialist - MQSeries
Back to top
View user's profile Send private message
Mohit Gupta
PostPosted: Wed Dec 08, 2004 1:53 am    Post subject: Reply with quote

Apprentice

Joined: 16 Sep 2004
Posts: 34
You can also achieve without PASSTHRU function

SET uid = COALESCE(THE (SELECT MIN(b.maint_by_uid) FROM VFAI.INTG_PARMS_DTL AS b) , 0);

SET Environment.Data[] = SELECT a.PARM1_TXT FROM VFAI.INTG_PARMS_DTL AS a WHERE a.maint_by_uid = uid

Cheers,
Mohit
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WBIMB 5.0 Database Select with database MIN() function
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
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.