Creating a Subfile of Sequential Numbers

[Pickering, John (NORBORD)]

Colin

Pick your biggest dataset as the primary file of your access statement (and
hopefully the only file). Choose an automatic master if you can so the
amount of data moved by each get is minimized.

Build the subfile in multiple passes appending to the existing data each
time. Prompt for a starting point each time -- the value you give should be
one less than the first number you want created. Set the input limit to some
conveniently round number. Repeat as many times as needed. Something like:

>request one
>access biggest-am
>define d-start int*6 = parm
>temp t-count int*6
>item t-count count reset at initial to d-start
>subfile sf100k keep append include t-count
>set input limit 10000
>set lock file update

Regards,
JWP

> -----Original Message-----
> From:	Colin Glass [SMTP: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
> 
>