Re: Taking out old part numbers

["McGovern, Sean" <Sean.McGovern@xxxxxxxxxxxx>]

Before deleting, consider archiving the data to be deleted to a backup
library. So, for example, data deleted from LF/ECH first gets archived
to BLF/ECH (LF being Live Files library and BLF being Backup Live Files
library). If you then ensure all the access paths for ECH also exist in
the backup library, you should be able to put the backup library at the
top of your library list and use standard BPCS functionality to
inquiry/report etc. against the archived data.

Works for us.



-----Original Message-----
From: bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+sean.mcgovern=covidien.com@xxxxxxxxxxxx] On
Behalf Of Don Cavaiani
Sent: 11 June 2009 21:59
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Taking out old part numbers

No vendors please.

Any warnings/caveats regarding use of strsql to delete very old part
numbers out of the database -e.g.,
IIM/CIC/HPO/MBM/ITH/ECH/ECL/FSO/FOD/FRT .....???

TIA

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063
 
"It's amazing what you can accomplish if you don't care who gets the
credit."  Harry S. Truman