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 » DELETE FROM not working

Post new topic  Reply to topic
 DELETE FROM not working « View previous topic :: View next topic » 
Author Message
MQMD
PostPosted: Mon Jun 04, 2007 8:31 pm    Post subject: DELETE FROM not working Reply with quote

Apprentice

Joined: 03 May 2007
Posts: 45
I am having a strange problem while executing delete clause from esql code.

The below statment is ineffective.It just do nothing on the database nor throws any error.
DELETE FROM Database.{Source1}.{Schema1}.{Table1} AS T WHERE T.REPLY_TO_Q = InputRoot.MQMD.ReplyToQ ;


the where clause is vaild as it works for select statment.Also the same is working from PLSQL.

How to move forward with this problem.
Back to top
View user's profile Send private message
MQMD
PostPosted: Mon Jun 04, 2007 10:27 pm    Post subject: Reply with quote

Apprentice

Joined: 03 May 2007
Posts: 45
Can any body suggest when to go for DataDelete node and when to use Delete clause.Also the prons of the same
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Tue Jun 05, 2007 2:13 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Your where clause MAY NOT be correct. You might not have the data you think you do.

Your {Source1} MAY NOT be correct.

Your {Schema1} MAY NOT be correct.

Your {Table1} MAY NOT be correct.

You'll have to troubleshoot th entire statement - every dynamic value in it - to confirm this.

Your statement MAY be absolutely correct, and it may be functional. And then your flow does something to roll back the transaction that the delete occurs in.
_________________
I am *not* the model of the modern major general.
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 » DELETE FROM not working
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.