SQL/MP Report Writer Guide

Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-2
SQL Database Reports
SQL Database Reports
SQLCI generates a default report definition for each SELECT command you enter
during your SQLCI session. You can override characteristics of the default report by
using the layout options, style options, and report formatting commands.
Layout and style options are not related to a specific SELECT command. These
options are global; they control general properties of reports. Layout options, such as
page length and margin settings, control the appearance of a report on the screen or
printed page. Style options, such as the decimal character, underline character, or
format of dates, control the appearance of items in a report. Your current layout and
style options affect the output of any SELECT command you enter during your SQLCI
session.
Report formatting commands specify a report template, including such elements as
detail lines, titles, and footings. These commands are related to a specific SELECT
command through database column references.
The report writer uses the information in the current report definition to format your
report. You can display or print data retrieved by the SELECT command in the default
report format that exists for each SELECT command by not using any of the style
Figure 1-1. Sample Content of Tables
VST0101.vsd
PARTNUM PARTDESC PRICE QTY_AVAILABLE
212
244
255
2001
6500
6603
7102
7301
PC SILVER, 20 MB
PC GOLD, 30 MB
PC DIAMOND, 60 MB
GRAPHIC PRINTER, M1
DISK CONTROLLER
PRINTER CONTROLLER
SMART MODEM, 1200
SMART MODEM, 2400
2500.00
3000.00
4000.00
1100.00
95.00
45.00
275.00
425.00
3525
4426
3321
2100
2532
430
2200
2332
ROWS
COLUMNS
ODETAIL Table
ORDERNUM
100210
100210
100210
100210
100250
100250
-
-
800660
800660
PARTNUM
244
2001
2403
5100
244
5103
-
-
7102
7301
UNITPRICE
3500.00
1100.00
620.00
150.00
3500.00
400.00
-
-
275.00
425.00
QTY_ORDERED
3
3
6
10
4
10
-
-
6
12