Hello listers,

i managed to create an escalation to run at 1AM everyday and change fieldId
from
imported to deleted for Run If: 'Create date' + (60 * 60 * 24 * 83) <=
$timestamp$

This tags the requests to be deleted.


I have to delete 20,000 daily. when i try to do a search on a form for
fieldId =
deleted, i get a message saying ARERR 94 - timeout during database query
blah blah blah.

Now that i have tagged the records to be deleted, whats the easy way to get
rid of them.

How can i use the Application-Delete-Entry to get rid of them.




help,tips,examples would be appreciated greatly.

Regards,

Ajay Paul

(IT Support Technician)

NCN Express Parcels, NCN HOUSE, Potters lane, Wednesbury, West Midlands,
WS10 OAS

Tel: 0121 506 7720 Fax: 0121 506 7711 Mobile: 0467 675644

The views and content of this message are those of the sender.
They do not necessarily imply that they are the views and opinions of NCN
Express Parcels;
the company accepts no liability for the content of this mail unless
expressly stated as such.

It may not be the best way, but I'd do this with a PERL script using the
ARS, DBD and DBI modules.

Read all the entry ids into an array with SQL straight to the db, the work
through the array with a foreach and delete them in turn with an
ars_DeleteEntry(); statement.

Or you could do a C app.


Neil Anderson
Senior Systems Developer
Halifax plc (UK)

disturbed@freewebaccess.co.uk
disturbed_uk@yahoo.com

Mobile: 07785 372821

'This message is attributable to the sender and does not necessarily reflect
the view of Halifax Group plc or its subsidiaries'


----- Original Message -----
From: "Ajay Paul"
To:
Sent: Thursday, December 21, 2000 3:11 PM
Subject: Creating macro to remove large data!


> **
>
> Hello listers,
>
> i managed to create an escalation to run at 1AM everyday and change
fieldId
> from
> imported to deleted for Run If: 'Create date' + (60 * 60 * 24 * 83) <=
> $timestamp$
>
> This tags the requests to be deleted.
>
>
> I have to delete 20,000 daily. when i try to do a search on a form for
> fieldId =
> deleted, i get a message saying ARERR 94 - timeout during database query
> blah blah blah.
>
> Now that i have tagged the records to be deleted, whats the easy way to
get
> rid of them.
>
> How can i use the Application-Delete-Entry to get rid of them.
>
>
>
>
> help,tips,examples would be appreciated greatly.
>
> Regards,
>
> Ajay Paul
>
> (IT Support Technician)
>
> NCN Express Parcels, NCN HOUSE, Potters lane, Wednesbury, West Midlands,
> WS10 OAS
>
> Tel: 0121 506 7720 Fax: 0121 506 7711 Mobile: 0467 675644
>
> The views and content of this message are those of the sender.
> They do not necessarily imply that they are the views and opinions of NCN
> Express Parcels;
> the company accepts no liability for the content of this mail unless
> expressly stated as such.
>
>
>

>