SQL/MP Report Writer Guide

Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-24
Using the Report Writer to Produce Text From Data
Figure 2-13. Example of Using the Report Writer to Produce Text From Data
?SECTION INVOCATION
AND I.FILENAME = F.FILENAME;
REPORT TITLE "-- DATE/TIME: ", CURRENT_TIMESTAMP AS DATE * TIME *,
- - GENERATE AN OBEY FILE FOR FILEINFO COMMANDS
LIST ALL;
DETAIL "FILEINFO ", CONCAT (COL 1 STRIP, ", DETAIL;");
WHERE I.TABLENAME LIKE ?TBOL AND TABLECODE NOT BETWEEN 500 AND 599
SKIP 1, "?SECTION FILEDATA";
FROM INDEXES I, FILES F
SELECT DISTINCT F.FILENAME
WHERE TABLENAME LIKE ?TBOL AND TABLECODE NOT BETWEEN 500 AND 599;
SELECT TABLENAME FROM TABLES
REPORT TITLE "--DATE TIME: ", CURRENT_TIMESTAMP AS DATE * TIME *,
SET STYLE HEADINGS OFF;
SET STYLE HEADINGS OFF;
SET LAYOUT PAGE_LENGTH ALL;
- - GENERATE AN OBEY FILE FOR INVOKE DIRECTIVES
SET LIST_COUNT 0;
SKIP 1, "?SECTION INVOCATION";
DETAIL "INVOKE ", CONCAT (COL 1 STRIP, ";");
LIST ALL;
?SECTION INFOFILE
SET LAYOUT PAGE_LENGTH ALL;
SET LIST_COUNT 0;
- -
- -
- -
- -
VST0213.vsd