Re: how to add 10,000 records to new file with one field setequal tocounter -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

Joel,

Here is one way to do it.

SQL -> Create Table QTemp/Test (Fielda dec(5,0))

CL -> InzPFM file(QTemp/Test) totrcds(10000)

SQL -> Update QTemp/Test Set fielda=rrn(Test)

Bill

----- Original Message -----

From: Stone, Joel

To: 'MIDRANGE-L@midrange.com'

Sent: Wednesday, April 26, 2000 7:51 AM

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 mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.