Re: Randomizing records in a file

The method used is all about what result Albert wants to get.

Is it to create a unique key for every row in the table or is it to
create a randomized index that can be re-randomized ?

In the case of creating a random unique key CEERANO isn't enough
because the seed has a max value of 2,147,483,646 and any seed
always will return a new seed and randomized number that is paired so
CEERANO is a very predicable routine, that is, if you know the seed
that goes in you also know what comes out.

Seed in = 1 always gives new seed and result
0950706376
+4.427071551059872E-001

Seed in = 0950706376 always gives new seed and result
0129027072
+6.008291247304665E-002

Seed in = 0129027072 always gives new seed and result
2097609136
+9.767753709930812E-001

In the case of creating a unique key I use the returned new
seed and add's a timestamp with all 6 digits in microseconds
and i start the seed in the serviceprograms by using the 6
digits microseconds retrieved when the serviceprogram is
initialized first time so I can have 10 or 20 service programs
generation unique keys running parallel.

In the case of just having to randomize a data set and
I would just use the returned seed and if it is a matter of
being able to re-randomize the dataset I would use either
the same 6 digit microsecond at jobstart or 0 as the initial
seed when starting the re-randomizing process.




On Wed, Jun 6, 2012 at 7:30 PM, <newnancy@xxxxxxxx> wrote:

That is what I was just saying to myself as I was reading some more notes
on this thread. It is the opposite of normal form. He can just take the
records like they are cards and mix them up.


Nancy
On Tue, 05 Jun 2012 14:14:48 -0500 Vern Hamberg <vhamberg@xxxxxxxxxxx>
writes:

Nancy, this made me smile a little - forgive my question, if need be
-
but randomizing means you don't look for an order, right?

<vbg> (that's a very big grin)
Vern

On 6/5/2012 9:53 AM, newnancy@xxxxxxxx wrote:

What exactly do you mean by randomize? What order are they in now?

What

order, if any, are you looking for?




Nancy
____________________________________________________________
53 Year Old Mom Looks 33
The Stunning Results of Her Wrinkle Trick Has Botox Doctors

Worried

http://thirdpartyoffers.juno.com/TGL3141/4fce1ecadf36d234caest04vuc
--
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.