SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
1-17
Report Functions
Report Functions
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.
MXCI Commands
Table 1-6 summarizes the MXCI commands that are useful when generating reports.
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
Table 1-6. MXCI Commands
Command Description
CANCEL Cancels the current SELECT command.
EXECUTE Executes a compiled command.
LIST Displays rows retrieved by the SELECT command.
LOG Starts or ends the logging of session activity to a file.
PREPARE Compiles a command. Useful for compiling a SELECT
command before producing a report.
RESET LAYOUT Resets layout options to default settings.
RESET REPORT Deletes commands from the current report definition or deletes
columns or alias names from stored report formatting
commands in the current report definition.
RESET STYLE Resets style options to default settings.
SELECT Retrieves data from tables and views.
SET LAYOUT Sets layout options to new values.
SET STYLE Sets style options to new values.
SHOW LAYOUT Displays the values of layout options.
SHOW REPORT Displays report formatting commands and the most recent
SELECT command.
SHOW STYLE Displays the values of style options.