SQL: set delete

["Reeve Fritchman" <Reeve@xxxxxxxxxx>]

This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I’m executing this SQL statement within my RPG program:

Delete from TOP001 where TOSTAT = ‘RT’

TOP001 contains “follow-up” records; they’re deleted every morning and new
ones are added based on some application logic.  When the program runs, it’s
possible that a user might have a record locked while doing their tracing
and follow-up; a locked record tanks the program with an SQL0913 error.  Is
there a way I can force the set delete to complete in spite of record lock
errors (even though such a “capability” is actually undesirable)?

The application doesn’t care if all the record(s) don’t get deleted; they’ll
be status’ed as closed and deleted the next day.  If there’s no easy way to
make the set delete work, I’ll do something else and delete on a
record-by-record basis (which will allow me to skip locked records).

Thanks,
Reeve
www.ltl400.com <http://www.ltl400.com/>

--