MQSeries.net :: View topic - Error delete statment .Plz help!!

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 » Error delete statment .Plz help!!

Error delete statment .Plz help!!

« View previous topic :: View next topic »

Author

Message

nheng

Posted: Thu Nov 04, 2010 9:18 pm Post subject: Error delete statment .Plz help!!

Apprentice

Joined: 07 Dec 2007
Posts: 39

DELETE FROM DB2xxx.GATEWAY_PROC AS G WHERE (G.UPDATETIME + 10 MINUTE ) < CURRENT_TIMESTAMP;
i try to run this statement in db2 .It's work.

But

DELETE FROM Database.DB2xxx.GATEWAY_PROC AS G WHERE (G.UPDATETIME + 10 MINUTE ) < CURRENT_TIMESTAMP;
After i deploy it and test it. error occer follow below:

Syntax error : expected ')' but found ''. :

Plz help!!!.

joebuckeye

Posted: Fri Nov 05, 2010 10:08 am Post subject:

Partisan

Joined: 24 Aug 2007
Posts: 365
Location: Columbus, OH

Quote:

DELETE FROM Database.DB2xxx.GATEWAY_PROC AS G WHERE (G.UPDATETIME + 10 MINUTE ) < CURRENT_TIMESTAMP;

If that line is really a line in your ESQL you need then you need to look up what the ESQL DELETE command really does.

Hint: It has nothing to do with database operations.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Error delete statment .Plz help!!

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