Q:Report w SQL Plus

Hello *.*,
I'm writing a report like this:
--------------------------SNIP ON-----------------------------------------
set echo off
set linesize 80
set pagesize 60

column today new_value today_date
select to_char(sysdate,'HH24:MM:SS DD-Mon-YYYY') today from dual;

ttitle left today_date right 'Seite : ' format 999 sql.pno skip 2 -  center '- Gebuchte, NICHT archivierte Belege -' skip 1

btitle skip 1 '*** D:\ORANT\SOFTMATI\LL0222.SQL ***'

spool d:\orant\softmati\ll0222.txt
select belegnummer from LL0222notinscan order by 1; spool off
host print d:\orant\softmati\ll0222.txt
exit
--------------------------SNIP OFF-----------------------------------------
If the select found any rows, the report looks ok. But if there no rows, it only write that there no rows found. How can I get the ttitle and bttitle, when no rows found.

Such report print automatically in the evening, and if there more reports with no rows I don't know which report it is.

bye ,
ralf
mailto:Ralf.Bender_at_wolnet.de Received on Thu Jul 16 1998 - 00:00:00 CDT