Thanks, I find a criteria by a column that has a number thats is growing and
it delete very fast. I already delete 20,0000,000 and I only need to delete
15,000,000 more millions.
> El 26/09/2017, a las 08:45, DOUG LAWRY <douglawry@hotmail.com> escribió:
>
> Hi Jorge.
>
> The standard tool is dbdelete in this open source ESQL-C package by Art
Kagel:
>
> ftp://ftp.iiug.org/pub/informix/pub/utils2_ak.gz
>
> Alternatively, it's easy enough to write a stored procedure to commit every
> few thousand rows. I have a general purpose one called spl_dbdelete which
uses
> dynamic SQL (needs IDS 11+) so that you pass in the table name and criteria.
> Perhaps I'll make my next article about that:
>
> https://www.oninitgroup.com/technical-articles
>
> Contact me directly if you want it sooner.
>
> Regards,
> Doug
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>