MQSeries.net :: View topic - passthru command to delete rows

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 » passthru command to delete rows

passthru command to delete rows

« View previous topic :: View next topic »

Author

Message

redcherry

Posted: Fri Jul 25, 2014 5:25 am Post subject: passthru command to delete rows

Newbie

Joined: 25 Jul 2014
Posts: 4

Hi,

Env - IB v9001, Linux

Database - Oracle v11

I would like to execute below sql command using esql - passthru statement.

delete from WMB_MSGS where TO_TIMESTAMP (EVENT_TIMESTAMP,'RRRR-MM-DD HH24:MI:SS.FF3') < (CURRENT_TIMESTAMP - interval '13' hour );

what would be the correct esql command using passthru()?

I am getting syntax error.

Thanks!

Vitor

Posted: Fri Jul 25, 2014 5:48 am Post subject: Re: passthru command to delete rows

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

redcherry wrote:

what would be the correct esql command using passthru()?

What did you use?

redcherry wrote:

I am getting syntax error.

What is the exact error?
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » passthru command to delete rows

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