SQL/MP Report Writer Guide

Introduction to the NonStop SQL/MP Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
1-15
Report Writer Components
Table 1-6. SQLCI 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.
OUT Specifies or closes the output file.
OUT_REPORT Directs the output of a SELECT command to a specific report
file or closes the current report 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 SESSION Resets session options to default settings.
RESET STYLE Resets style options to default settings.
SELECT Retrieves data from tables and views.
SET LAYOUT Sets layout options to new values.
SET SESSION Sets session options to new values. Only the LIST_COUNT
session option is described in this manual.
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 SESSION Displays the values of session options.
SHOW STYLE Displays the values of style options.
Note. The LIST_COUNT session option specifies the number of rows the LIST and SELECT
commands display.