Open and close .lis file

["Manning, Shinta" <shintamanning@NFISG.COM>]

I am trying to produce reports out of one program that will print to
different .lis files.  For example, let's say there are 40 departments who
wants to get this report every week. All 40 may have variable selection
criteria.  For example, department 1 wants all customers, department 2 wants
customers with balance > $500, etc.  So my pseudo program would look like
this:

    DO getOccurrrence
    while not done processing all occurrence
             DO openLISFile
             DO printReport       !where this will have the BEGIN-SELECT
statement
             DO closeLISFile
             DO getOccurrence
    end-while


As I understand it, SQR 'opens' .lis file at run time, and 'closes' .lis
file when the program ends.  Is there anyway that I can open and close .lis
file 'manually'?  Could it be an option at the command line?

Another way that I thought might work if opening and closing of LIS file is
not possible, is to print report for the current occurrence to the .lis file
like I normally would, then copy the existing content to another file for
that occurrence, CLEAR the LIS file so I'll have a clean LIS file for the
next occurrence.  My pseudo program would look like the following:

    DO getOccurrence
    while not done processing all occurrence
             DO printReport
             DO copyLISToNewFile
             DO clearLISFile
             DO getOccurrence
   end-while

 But I haven't found an SQR utility that will CLEAR the LIS file. Can
someone tell me if there is a utility that will do that?


Thanks so much =)