RE: record with duplicate key

Unless my memory is completely messed up, if you go into the joblog of the
job getting the error, the first message about the unique key violation
specifies which file owns the access path that is the problem.  This may be
in the second level text, I don't remember for sure.

Unfortunately, the problem with the application vendor that we use here is
that there aren't enough unique keys defined to the database, so we're
constantly dealing with records that shouldn't be there rather than getting
duplicate key errors that we could correct more quickly.  Sigh.

-----Original Message-----
From: Jim Langston [mailto:jimlangston@conexfreight.com]

DSPDBR (Display Database Relations).  give it the file name, and look at
the logicals and their keys.  DSPFD to display the key information for the
File(s).

Regards,

Jim Langston

"Ray, Adam" wrote:
> 
> Where do I find that information?
> 
>         Your unique key may be on a different index against the physical
> file.  Find where your UNIQUE key is enforced.
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---