Re: Write a record at a specific RRN

No, you can't get around constraints (unique keys, etc.): you can't INFZPFM
records into a file with a unique key constraint. Add the record using
sequential IO (obeying all constraints) and then you can access that record
via RRN.

On Wed, Aug 11, 2021 at 1:58 PM Paul Nicolay <paul.nicolay@xxxxxxxxxx>
wrote:

I don't see what that solves ?

Writing the external DS (with dummy data) will still have possible
constraint issues.
________________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
Francois Lavoie <Francois.Lavoie@xxxxxxxxxxxxxxxxxxxx>
Sent: Wednesday, August 11, 2021 22:42
To: RPG programming on IBM i
Subject: RE: Write a record at a specific RRN

What about doing all in a external DS ?


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Paul
Nicolay
Sent: Wednesday, August 11, 2021 16:40
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Write a record at a specific RRN

Caution: This email originates from outside of Fresche | Attention: Ce
message provient de l'extérieur de Fresche


Hi,

The concept is that I don't know the file definition... ie. unique keys,
constraints, ... so writing dummy records is not possible as it might
violate the restrictions.

Even if it would work, once I write a dummy record I don't know if it is
"occupied" or not.

Kind regards,
Paul
________________________________________
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Alan
Campin <alan0307d@xxxxxxxxx>
Sent: Wednesday, August 11, 2021 22:13
To: RPG programming on IBM i
Subject: Re: Write a record at a specific RRN

Maybe I am missing something but couldn't you first determine how many
records in the file so in your example you have 3 records.

Next just write 7 more records with blanks or dummy.

Finally chain RRN 10 and update it.

On Wed, Aug 11, 2021 at 11:44 AM Paul Nicolay <paul.nicolay@xxxxxxxxxx>
wrote:

Hi,

I was wondering if there's a method to write a record at specific RRN
in a file.

The RRN will not exist yet, so for example I have a file with RRN 1, 2
and 3... and I want to write RRN 10.

Kind regards,
Paul
--
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@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
Confidentiality Warning/Avertissement de confidentialité:

This message is intended only for the named recipients. This message may
contain information that is privileged or confidential. If you are not the
named recipient, its employee or its agent, please notify us immediately
and permanently destroy this message and any copies you may have. Ce
message est destiné uniquement aux destinataires dûment nommés. Il peut
contenir de l'information privilégiée ou confidentielle. Si vous n'êtes pas
le destinataire dûment nommé, son employé ou son mandataire, veuillez nous
aviser sans tarder et supprimer ce message ainsi que toute copie qui peut
en avoir été faite.
--
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@xxxxxxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com