|
On 14/02/2006, at 8:37 AM, Lim Hock-Chai wrote:
midrange.com
A K FAKEY2
- FILEB contains two records: AAA and BBB.
- Why would the following cause duplicate key error?
When I add FAKEY1=AAA, FAKEYB=1234567890 to FILEA. It added ok.
However, when I try to add CCC, 1234567890 to FILEA, I get a duplicate
key error.
Because FILEAJ0 is keyed UNIQUE on FAKEY2.When you add a record to a PF all access paths, including LF, are checked for uniqueness.
The record you are adding is unique to FILEA but a duplicate in FILEAJ0. Regards, Simon Coulter. -------------------------------------------------------------------- FlyByNight Software AS/400 Technical Specialists http://www.flybynight.com.au/ Phone: +61 3 9419 0175 Mobile: +61 0411 091 400 /"\ Fax: +61 3 9419 0175 \ / X ASCII Ribbon campaign against HTML E-Mail / \ --------------------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
