Help Please. Stored procedure to delete records...

Posted in 2007

Kern Doe — Fri, 16 Nov 2007 14:35:59 — source: IIUG Forums & Mailing Lists

Does anyone have a stored procedure that performs deleting records from a table, perhaps, this sp should commit every 500 records or so? Thanks. ________________________________________________________________________________ ____ Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ

↪ replying to Kern Doe

Art Kagel — Sun, 18 Nov 2007 14:56:54 — source: IIUG Forums & Mailing Lists

Get my dbdelete utility in the package utils2_ak from the IIUG Software Repository. Very fast and very flexible. Dbdelete is much faster than any SPL delete procedure can be. Art S. Kagel On Nov 16, 2007 9:35 AM, Kern Doe < kern_doe@yahoo.com> wrote: > Does anyone have a stored procedure that performs deleting records from a > table, perhaps, this sp should commit every 500 records or so? > Thanks. > > > > ________________________________________________________________________________ ____ > Be a better sports nut! Let your teams follow you > with Yahoo Mobile. Try it now. > http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Art Kagel

Kern Doe — Sun, 18 Nov 2007 16:34:55 — source: IIUG Forums & Mailing Lists

Thanks Art, I will check it out. Have a happy ThanksGiving. ----- Original Message ---- From: Art Kagel <art.kagel@gmail.com> To: ids@iiug.org Sent: Sunday, November 18, 2007 9:56:55 AM Subject: Re: Help Please. Stored procedure to delete re.... [10403] Get my dbdelete utility in the package utils2_ak from the IIUG Software Repository. Very fast and very flexible. Dbdelete is much faster than any SPL delete procedure can be. Art S. Kagel On Nov 16, 2007 9:35 AM, Kern Doe < kern_doe@yahoo.com> wrote: > Does anyone have a stored procedure that performs deleting records from a > table, perhaps, this sp should commit every 500 records or so? > Thanks. > > > > ________________________________________________________________________________ ____ > Be a better sports nut! Let your teams follow you > with Yahoo Mobile. Try it now. > http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Get easy, one-click access to your favorites. Make Yahoo! your homepage. http://www.yahoo.com/r/hs