We use the Insert (SQL) and CPYF commands quite a bit. The FIRST thing I do
is analyze the tables and figure out what we want to accomplish. I have yet
to run into a situation where we would want duplicate records.
Sometimes we create a logical with additional keys to "eliminate"
duplicates, perhaps you could try this?
Colin's post has useful information to keep in mind also.
S. E. Tuthill
A73 C11 V5R3
From: Colin_Hugill [mailto:
[email protected]]
Sent: Thursday, May 12, 2005 7:48 AM
To:
[email protected]
Subject: RE: CPYF/SQL INSERT problem - Duplicate Key
Hmmmnnn, SKOREK where did you study computer analysis?
Question 1. Did you carefully and thoroughly review (emphasis on
"thorough" and "careful") the joblog when you tried the CPYF command?
Probably not, because the copy normally stops at the error record - so
the remaining (in your terminology "uncopied") records may, OR MAY NOT,
cause duplicated keys. There is enough information in the detailed
joblog to find the record causing the error, if you look properly.
Question 2. Why would you want to copy records that cause "duplicate
key" errors?? The message is trying to tell YOU something. Maybe you
haven't done enough analysis yet or maybe what you are trying to copy
has already been copied in an earlier attempt and therefore shouldn't be
copied again! Maybe you should clear the target file and start again.
I am sure there are several organizations that offer in depth courses on
IBM Commands and Basic Analysis, you should use them. This list is
about JDE World software - you might help yourself by letting us know
what files you are using (i.e. copying from and copying to).
Regards,
Colin
Colin Hugill (Consultant) (World A7.3 cum12)
_____
The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.
Looking for a job? Check out the Job
This is the JDELIST World Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwards(r).
.