Re: referential integrity

["Chick Doe" <Cdoe@xxxxxxxxxxxxxxxxxxxxxx>]

there are several programs within the bpcs SYS menu that do this function. they 
look for things like order line without order headers, etc. other than that we 
have written some query programs that look for specific errors within our data 
base. we run these periodically. other than that i am not aware of any 'data 
base' wide utility program. such a program could take a while to run!

chick doe 
barton instrument systems, 

>>> MDamon@agrilinkfoods.com 11/22/00 11:57AM >>>
Does anyone know of a product that examines the data loaded in to BPCS and
evaluates key records for referential integrity?

Mitch Damon, CPIM
Planning Systems Manager
Logistics - Rochester, NY
(716) 383-1070 ext.250

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com 
+---

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---