Re: Removing Soft-Deleted records from BPCS Files -- BPCS-L

Hi Andrew,

Further to the excellent advice already provided on this board, I would justlike to say that you can get an evaluation copy of the Archiving tool peoplehave mentioned either from us in the UK, or from Unbeaten Path in the US. Weat Small Blue are the authors of the tool which over here is known as'Archiving for BPCS', however our partners Unbeaten Path sell it on theother side of the pond as 'Locksmith'.

We also provide BPCS SQL tuning services! References for this in Irelandinclude Novartis Dublin, and ABS Pumps in Wexford.

Let me know if you need any further information or help,

best regards,

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified iSeries Systems Professional
Email: Clare.Holtham@xxxxxxxxxxxxxxx

----- Original Message -----From: "Andrew" <andrewroe@xxxxxxxxxx>

To: <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, October 04, 2005 8:07 PM
Subject: [BPCS-L] Removing Soft-Deleted records from BPCS Files

I have been asked to look into ways of removing 'soft-deleted' records from

our BPCS 6.1 database. For example our FMA file has over 2.3 millionrecord

of which 2.2 are 'soft-deleted'.
Before I go down the programming route I would appreciate any advice the
forum can give me regarding files that can be successfully cleaned-up and
what files should not be touched.
I am aware of the BPCS supplied cleanup routines but am of the

understanding that they target specific files or data-sets and do notapply

soft-deletes across all of the BPCS tables?

Regards,
        Andrew
*************************** ADVERTISEMENT ******************************
Get BT Broadband from only EUR15 per month! Enjoy always-on internet
for less! Check it out at http://www.btireland.ie
--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: Clare.Holtham@xxxxxxxxxxxxxx