SQL/MP Report Writer Guide

Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-21
Using the Report Writer to Produce Text From Data
RPXSTATS produces the following three files:
•
SQLUPDS, for the statistics
•
FILEINF, an intermediate command file that creates the SQLFILES file
•
SQLFILES, a file for the INVOKE directives and FILEINFO commands
The RUNXREPS command file purges any pre-existing data from these files using the
CLEAR option. Therefore, you need to rename SQLFILES and SQLUPDS to save
them if you want to evoke the RUNXREPS command file more than once.
The following example illustrates the RUNXREPS command file. Note that the file
named FILEINF created by the OUT_REPORT command is then immediately invoked
by the OBEY FILEINF command.
OUT_REPORT SQLUPDS CLEAR;
OBEY RPXSTATS(COLSTATS, BASETAB, INDEXNFILES);
OUT_REPORT FILEINF CLEAR;
OBEY RPXSTATS(INVOCATION,INFOFILE);
OUT_REPORT ;
OUT SQLFILES CLEAR;
OBEY FILEINF (INVOCATION,FILEDATA);
OUT ;
Figure 2-11, Figure 2-12, and Figure 2-13 illustrate the RPXSTATS command file.