SQL SQLORA PREPARE SQLOUT FOR
SELECT
A.SCHEDULEID "SCHEDULE ID",
B.STARTDATE "START DATE",
A.DOMAINHREF "DOMAIN"
FROM
BOTCAT A,
BOTSCHED B,
WHERE
A.SCHEDULEID = B.SCHEDULEID
B.STARTDATE < &AS_OF_DATE
ORDER BY B.STARTDATE
END
-*---------------------------------------------------------------------------------------------------------------------
TABLE FILE SQLOUT
PRINT
SCHEDULE_ID AS 'Schedule Id'
START_DATE AS 'Start Date'
DOMAIN AS 'Domain'
WHERE (DOMAIN EQ '&DOMAIN.Enter Domain:.' OR '&DOMAIN' EQ '');
ON TABLE PCHOLD FORMAT COMT
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.250000,
     RIGHTMARGIN=0.250000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.250000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,COLUMN=SCHEDULE_ID ,WRAP=2,$
TYPE=REPORT,COLUMN=JOBDESC,WRAP=4.5,$
ENDSTYLE
END

SET EMPTYREPORT=ON

quote:

The EMPTYREPORT parameter controls the output generated when a TABLE request retrieves zero records.

EMPTYREPORT is not supported with TABLEF or Excel. When a TABLEF or Excel request retrieves zero records, an empty report is generated.

Note: Using the IF TOTAL or WHERE TOTAL phrases when EMPTYREPORT is set to OFF may produce an empty report if there is no data that satisfies the TOTAL condition. This occurs because the test for report lines for EMPTYREPORT is applied before the the TOTAL condition is applied.

The syntax is:

SET EMPTYREPORT={ANSI|ON|OFF}
where:

ANSI - Produces a single-line report and displays the missing data character or a zero if a COUNT is requested. in each case, &RECORDS will be 0, and &LINES will be 1.

If the SQL Translator is invoked, ANSI automatically replaces OFF as the default setting for EMPTYREPORT.

ON - Produces an empty report (column headings with no content). This was the default behavior in prior releases.

OFF - Produces no report output. OFF is the default value except for SQL Translator requests. When the SQL Translator is invoked, ANSI replaces OFF as the default setting for the EMPTYREPORT parameter, so the results are the same as for the ANSI setting.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

quote:

SET DISTRIBUTE=OFF
Task finished.
No report to distribute.