HP NonStop G-Series - Manual (Page 94)

Formatting Reports and Plots
Measure User’s Guide — 520560-003
4- 34
Generating Reports Using Enform and SQL/MP
Products
The DDL command creates a dictionary in your current subvolume and writes to an out
file the records entered into it. The OUT option sends the list of records to the default
printer. There should be 14 files on your subvolume, each beginning with DICT.
Generating Reports Using Enform and SQL/MP Products
For a description of how to produce reports using Enform queries, see Appendix A,
Creating an Enform Report From Measure Data . For more Enform information, see the
ENFORM User’s Guide and the ENFORM Reference Manual.
To generate reports using the NonStop SQL/MP Report Writer:
1. Use the SQLCI CONVERT utility to load the data in the structured file into an SQL
table.
2. Use the NonStop SQL/MP Report Writer to perform any report writing function on
the data.
For More Information
•
For brief procedures for converting a Measure data file to an SQL table, see
Appendix C, Loading Measure Data Into an SQL Table .
•
For detailed information about the CONVERT utility, see the NonStop SQL/MP
Reference Manual.
•
For information about the NonStop SQL/MP Report Writer, see the NonStop
SQL/MP Report Writer Guide.
Loading Data From Different Systems to Common Files
Data from multiple systems running the same Measure PVU can be combined in a
common set of structured files. However, in general, report processing time increases if
a query must sort through more records to find the ones pertinent to the request. To
distinguish records from different data sets in queries and reports, use LOADID.
If systems are running different Measure PVUs, combining data is more difficult:
•
For legacy-style data (Measure G10 and earlier), records can be combined only if
the record format for the entity is unchanged between the PVUs. If the record
lengths differ, MEASFH does not write to the file. To combine data in this case:
1. Create files in separate subvolumes.
2. Use FUP COPY with the truncate or pad options to load the additional data
from one subvolume into the files of the other subvolume.
•
For ZMS-style records (Measure G11 and later), MEASFH writes data from any
PVU to an existing file in the format of the data already in the file. MEASFH
truncates records or pad hdr, id, or ctr sections of the record with zeros as needed
to fit the format of the existing file. The padding might place binary zeros in a field
defined for ASCII data. Use a dictionary and files of the oldest PVU format your