Re: Randomizing records in a file

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