Re: Randomizing records in a file

[Albert York <alfromme@xxxxxxxxx>]

This seems to be the simplest way. I can add a field containing a
random number plus the record number and use a logical over it.

Thanks everyone.

Albert

On Mon, Jun 4, 2012 at 12:21 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:
> We have a couple procedures which are based on the CEERANO api; one to generate random numbers, another to generate random strings. Do you have a field in your 12 million record file for storing a random value? If not, consider generating a new table with one column containing a random value, and another field containing a sequential number representing the record number of the other file.
>
> -Nathan.
>
>
>
> ________________________________
>  From: Albert York <alfromme@xxxxxxxxx>
> To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
> Sent: Monday, June 4, 2012 12:58 PM
> Subject: Randomizing records in a file
>
> I have a file that contains around 12 million records. I need a way to
> randomize the order of the file in the most efficient method. Does
> anyone have any ideas?
>
> Thanks,
>
> Albert
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.