Dynamic Subfile naming

Deskin, Bob Bob.Deskin@Cognos.COM
Thu, 21 Oct 1999 12:23:40 -0400


I'm sure someone can better this, but here's an idea:

Do a prepass where you determine which subfiles are needed and write out the
appropriate subfile statements to a NODICT subfile. This file gets USEd in
the second pass.

You would read your file, sort on the item you want to subfile on (to
Subfile - any noun can be verbed), and then write out the statements AT
item.

The format of the statement is something like:

SUBFILE SUB<name> KEEP IF item = <name> INCLUDE file

This should be easy to put together by concatenation.

Bob Deskin              
PowerHouse Web Product Manager and Senior Product Advisor
Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 4205 FAX: (613) 228-3149
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: Al Karman [mailto:alkarman@hotmail.com]
Sent: Thursday, October 21, 1999 11: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           '
              '''''''''''''''''''''''''''''''''''''''

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.