Dynamic Subfile naming

Pickering, John (NORBORD) PICKERIJ@norbord.com
Thu, 21 Oct 1999 14:00:39 -0400


You could do it all in Quiz if you don't mind reading the input file as many
times as there are users-ids! Pass through the input file first and generate
Quiz source as per previous suggestions something like the following for
each user-id. Then feed this source to Quiz. 

>access inputfile
>select if user-id = "xxxx"
>set subfile name xxxx 
>report summary all
>go

John Pickering
Toronto

> -----Original Message-----
> From:	Rohde Dirk (Van) [SMTP:Dirk.Rohde@vpgroup.com]
> Sent:	Thursday, October 21, 1999 1:43 PM
> To:	'Al Karman'
> Cc:	powerh-l@lists.swau.edu
> Subject:	RE: Dynamic Subfile naming
> 
> How about a quiz report that is run first to write a qtp routine to create
> the subfiles?  You would need a "footing at User-ID..." statement to write
> out each "subfile..." statement.  Watch out for exceeding the 31 file
> limit,
> though.  You'll need to put in some kind of break every 30 or so users to
> write out new requests.
> 
> -----Original Message-----
> From: Al Karman [mailto:alkarman@hotmail.com]
> Sent: Thursday, October 21, 1999 8:54 AM
> To: powerh-l@lists.swau.edu
> Subject: Dynamic Subfile naming
> 
> 
> Happy Thursday, fellow listers....
> 
> I'd appreciate some assistance on the following:
> 
> I'm reading thru a detail set, and I'm sorting and setting my subfile on
> the
> 
> User-ID.  I'm getting values like <USER1>, <USER2>, etc...
> 
> Can someone out there divulge the secret whereby I can dynamically create 
> and name the subfiles AT the User-ID break (subfile USER1 contains just 
> User-ID's=<USER1>, subfile USER2 bla bla bla y'all get the idea!)
> 
> In your debt for all eternity or 1/1/00, whichever comes 1st!
> 
> PS - Go Yankees (from a suicidal Mets fan!)
> 
>               '''''''''''''''''''''''''''''''''''''''
>               '             Al Karman               '
>               '  Information Technology Consulting  '
>               '   Internet:  alkarman@hotmail.com   '
>               '        FAX:  248.671.5035           '
>               '''''''''''''''''''''''''''''''''''''''
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.