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.