Re: Duplicates in BPCS files - illusion?

[DAsmussen@xxxxxxx]

Al,

In a message dated 6/2/99 5:30:39 PM Eastern Daylight Time, 
MacWheel99@aol.com writes:

> What causes duplicates?
<<snip>>

Duplicates are caused by the fact that SSA doesn't specify the UNIQUE keyword 
on logical files that should be.  They instead count on programmers to follow 
standards to prevent duplicates, which is equivalent to counting on all 
politicians to be honest (perhaps worse).  If you are having problems with 
duplicates on a particular file and don't have a high availability system in 
place, start journaling on the files in question and do a TYPE2 dump to a 
database file when you find any duplicates.  That will point out the program, 
user, date, and time of the offending program...

HTH,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-mail:  DAsmussen@aol.com

"The average tourist wants to go to places where there are no tourists." -- 
Sam Ewing
+---
| 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
+---