[Info-Ingres] Time limited SQL

[Roger Hill]

Hi.

I have a job (delete from x where y...)
that runs for many hours (not on Ingres I hasten to add).

Does anyone here know a way to write self-terminating code along the lines of

delete from x where y ..
and time <5am

so that when 5am comes it shuts itself down cleanly? (And I'll just run it
again the next night, to delete a few more rows).

I can from an external monitor kill the SQL at 5am, but I need it to be a
clean termination, not just a kill.

Any ideas? Am I missing something blindingly obvious?

Thanks
Roger

################################################
Roger Hill                        07739 707 180
################################################