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

["Allen, Stuart" <sallen@xxxxxxxxxxxx>]

I've done a similar type of thing before.
I used MS Excel!  If you define a cell as the previous (vertical) cell + 1,
and drag down from that cell - you've got your records.
i exported this as a .csv, and uploaded it to a physical file on the 400.
total time taken - about 3 minutes.

There may be a clever way to do it solely on the 400, but this method works
for me!

Regards,
Stuart
                                     
Stuart Allen
European Systems Analyst
Fellowes

mailto:sallen@fellowes.com

> -----Original Message-----
> From: Stone, Joel [SMTP:StoneJ@GourmetAward.com]
> Sent: Wednesday, April 26, 2000 3:51 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      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!
> 
+---
| 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
+---