Just a follow-up note on this duplicate records for unique keys.
The application vendor never intended to allow field 2 to have more than one
unique entry. Maybe they should have placed that field before field 1 when
designing this KSAM, however, no matter what I did I could not get the new
KSAM file to allow me to enter duplicate information from the original KSAM
when built the way the old one was.
So my resolution for the time being is to remove the duplication and resize
the file using a SUPRTOOL to remove the duplicate keys before outputting the
data to the new size ksam file. Meanwhile I wrote a little report to let me
know if this happens again so I can notify my application developer and
hopefully find out what is causing this.
Meanwhile, while I am on a role of data duplication, I also found duplicated
unique primary key information in a detail image dataset - needless to say
we are also cleaning this up and writing another report to find out what is
doing this (my thinking is the Cobol code has some bugs - but who is to
say).
Thank you all for the help,
Cat
*****************************
Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital
15107 Vanowen Street, Van Nuys, CA 91405 (818)782.6600 x 2140
[log in to unmask]
********************************
The thoughts, comments, and opinions expressed herein are mine. They do not
reflect those of my employer, nor anyone else.
********************************
This E-mail is covered by the Electronic Communications Privacy Act, 18
U.S.C. §§ 2510-2521 and is legally privileged. This information is
confidential information and is intended only for the use of the individual
or entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this transmission in error, please notify the sender immediately by return
electronic transmission and then immediately delete this transmission.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
