Creating a Subfile of Sequential Numbers

[Daniel Mielke]

Hi Colin,

What is the largest file size that you have available in terms of number of
records?

Try the following in Quiz:

set report limit 10000
access <file with at least 10000 records>
define xxx numeric*9 = 1
report summary xxx subtotal noreset
set subfile name <filename> keep
go

-And then run this part 9 times:

set report limit 10000
access <file with at least 10000 records>
define xxx numeric*9 = 1
report summary xxx subtotal noreset
set subfile APPEND name <filename> keep
go

- Finally:

set report limit 999999
access *<filename>
define yyy numeric*9 = 1
report summary yyy subtotal noreset
set subfile name <finalfile> keep
go

Your requested result would exist in "finalfile".

You can adjust this for the largest size file that you have so that you
don't have to repeat the center part as often.

Essentially this is the extended version of "Bookwood"'s suggestion.

If you don't have anything as big as 10K records I would suggest using a
"USE" file to repeat the append action several times.

> BUY. HOLD. AND PROSPER.
> 
> Daniel Mielke
> Senior User Analyst
> AIC Limited
> 1-888-710-4242 (4614)
> dmielke@aicfunds.com
> www.aicfunds.com
> 


-----Original Message-----
From: Colin Glass [mailto:cglass@mlcc.mb.ca]
Sent: Tuesday, September 25, 2001 12:55 PM
To: powerh-l@lists.swau.edu
Subject: Creating a Subfile of Sequential Numbers


Using PowerHouse version 8.19.C5 on an HP3000 with an Image database.

How can I create a subfile of sequential numbers from 1 to 999999?  We do
not have any datasets or files that have that many records in it to access. 


Thank you in advance.

_______________________________
Colin Glass - cglass@mlcc.mb.ca
Senior Programmer/Analyst
Manitoba Liquor Control Commission
Ph:  (204) 474-5597

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.