RE: how to add 10,000 records to new file with one field setequal tocounter

Business problem:

Salesperson file exists to validate salesperson ID during order entry.  For testing, I wanted to populate the entire file with all possible salespeople (0001 thru 9999) so users can test application and not worry about entering an invalid salesperson ID.

Any better ideas???

I was curious to know if this is possible on the /400 with a tool such as SQL or Query/400 or something else without writing a program!

-----Original Message-----
From: John Earl [mailto:johnearl@400security.com]
Sent: Tuesday, April 25, 2000 6:53 PM
To: MIDRANGE-L@midrange.com
Subject: Re: how to add 10,000 records to new file with one field
setequal tocounter

David Morris wrote:

>I
> also don't understand why you would want to do this, if you want a unique key, I would
> retrieve an external sequence, or a time stamp.

Or use the actual RRN itself.  I agree with David, use anything
but an artificial (and virtually guranteed to get out of sync)
sequential number.

Joel, I think that this field may end up causing more problems
than whatever it is designed to solve. 

Do you mind me asking, what is the Business Problem you're trying
to solve?

jte

--
John Earl                               johnearl@400security.com
The PowerTech Group                     206-575-0711
PowerLock Network Security              www.400security.com
--
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---