Re: on-break (?)

[Denise White <dewhite@VICR.COM>]

Mike,

Two possibilities come to mind.

Perhaps your SELECTs are not picking up any data.  If there is no output, the
program will not produce a report file at all.  Check your logic in a SQL Tool
(SQLTalk, SQL*Plus, etc.).  Alternately, create a flag in your program and set
it on within the BEGIN-SELECT paragraph.  At the end, check the flag and if it
is not on, print 'NO DATA FOUND'.  Since you are then doing a print, the program
will create a .lis file.  I also use this method when there is a possibility
that there will be no data for a particular run, in order to wipe out the report
from the previous run - before I did, my users would get very confused when they
would find the previous week's data in their report!

The other thing I can think of is that the .lis files may be being written to a
different directory than you expect.  Check your SQR flags for the -f flag (for
example, 'c:\temp\' - you need the final slash).  This specifies where the
output is written.  If there is no -f flag, the .lis files are written to the
directory where the SQR or SQRW executable resides.

BTW, your question did not seem to have any relationship to the message you
responded to ('on-break').  To avoid confusion, if you are starting a new
thread, you really should create a new subject and not include an unrelated
message in your response.

HTH,
Denise White
Sr. Programmer/Analyst
Vicor

-----------------------------

Date:    Tue, 5 Dec 2000 13:45:51 -0500
From:    Mike Morgan <MMorgan@CHASEMELLON.COM>
Subject: Re: on-break

I have an SQR that prints 2 reports.  I define them in the setup section as
Report1 and Report2, and then reference them individually with
use-Report1,  use-Report2.  I have verified that my code enters both print
routines, but when the pgm ends, there are no reports.
Does anyone know what could be causing this?  Thanks.