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-----
[] 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.,


Don F. Cavaiani
IT Manager
Amerequip Corp.

"It's amazing what you can accomplish if you don't care who gets the
credit." Harry S. Truman

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].