Re: EXCPT output RPG

[Jose Perez <joseenocperez.jp@xxxxxxxxx>]

Could it be possible that your file has a constraint (DSPCPCST)?. Why don't
you try the update outside of your program and see what happen, if possible
of course.

On Fri, Aug 9, 2019, 12:24 PM Therrien, Paul via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

> My first thought too.  But, i would expect to see file name of the logical
> file with the duplicate key in the job log.  I am not seeing this.
> The joblog shows the current file (a logical file), as the file with the
> duplicate key error.
>
>  Paul
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
> Eric Hill via RPG400-L
> Sent: Friday, August 9, 2019 12:17 PM
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Cc: Eric Hill <ehill@xxxxxxxxxxxxx>
> Subject: RE: EXCPT output RPG
>
> Just off the top of my head:
>
> Could it be possible that a logical over that file has unique keys?  We've
> run into that before....
>
> Eric Hill
> Senior Software Developer
> Integrated Corporate Solutions
> ehill@xxxxxxxxxxxxx
> 256-760-8239
>
> NOTICE:
> This message may contain privileged or otherwise confidential information.
> If you are not the intended recipient, please immediately advise the sender
> by reply e-mail and delete the message and any attachments without using,
> copying or disclosing the contents.
>
>
>
> -----Original Message-----
> From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
> Therrien, Paul via RPG400-L
> Sent: Friday, August 09, 2019 11:13 AM
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Cc: Therrien, Paul <ptherrien@xxxxxxxxxxx>
> Subject: EXCPT output RPG
>
> Just want to verify something...
> In an RPG program we have exception output (an update, not ADD), to a
> record format that specifies the fields to be updated.
> Only the fields listed in the exception output can be updated. Correct?
>
> I am trying to track down why we are getting a duplicate key error on this
> exception output when the exception output does an update to an existing
> record and the key fields of that record are not listed in the exception
> output.
>
> My perception is that I am going down a rabbit hole barking up the wrong
> tree while chasing a wild goose, but I have to start somewhere.
>
> Happy Friday!
>
> Paul
>
> +++++ This email and related attachments may contain confidential
> information intended exclusively for the addressee. Unauthorized use,
> disclosure or distribution of this material is prohibited. If you received
> this message in error, please advise the sender and delete all copies of
> it. Content is provided by the individual sender and does not necessarily
> reflect the views of the Company. Though sender believes this transmission
> to be virus-free, it is the recipient's responsibility to ensure that it is.
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a
> message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list To post a
> message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
> change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com