SQL/MP Report Writer Guide

Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-14
Report Writer Components
Report Function
Report functions provide timestamps (both current and for a specified date and time),
the current line number, and the current page number. The report functions are
summarized in Table 1-5.
SQLCI Commands
Table 1-6 summarizes the SQLCI commands that are useful when generating reports.
Table 1-4. Layout Options
Layout Option Default What the Option Defines
CENTER_REPORT OFF Centering of the entire report
LEFT_MARGIN 0 Left margin of the report
LINE_SPACING 1 Number of lines to advance before the next
line
LOGICAL_FOLDING ON Whether an item of the default detail line
moves to the next line when the item does
not fit within the margins
PAGE_COUNT ALL Maximum number of pages
PAGE_LENGTH ALL (terminal)
60 (other devices)
Number of lines per page
RIGHT_MARGIN Output device
width
Right margin of the report
SPACE 2 Number of single-byte spaces between
columns
WINDOW TAB 1 Print item or print position to display at the
left edge of the output device
Table 1-5. Report Functions
Function Value Returned
COMPUTE_TIMESTAMP Timestamp for a specified date and time
CURRENT_TIMESTAMP Timestamp for the current date and time
LINE_NUMBER Current line number within a break group, page, or report
PAGE_NUMBER Current page number