Creating a Subfile of Sequential Numbers

[Blue]

G'day Colin

Try using an environment variable to 'seed' a counter and run a QTP routine
several times, each time appending to the subfile.  For example, say you can
find a file or dataset that contains 100,000 records.  The first time
through set the variable to 0 and increment a counter in QTP by one.

RUN x
REQ 1
SET PROCESS LIMIT 100000
ACC bigfile
TEMP cntr
ITEM cntr INITIAL GETSYSTEMVALUE('cntrseed')
SUB NAM bigsfile KEEP
  ITEM id = cntr + 1

ITEM cntr = cntr + 1
GO

Modify the syntax slightly so the subfile is APPEND rather than KEEP, change
the environment variable to 100000 and run the job again.  Keep doing this
until you get enough records.  The last time through set the process limit
to 99999.

Regards,
Blue

PS. Still looking for a gig!!!

> -----Original Message-----
> From: powerh-l-admin@cube.swau.edu
> [mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Colin Glass
> Sent: Tuesday, September 25, 2001 11:55 AM
> 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.
>