SQL/MP Report Writer Guide

Comparison of the Report Writer and the Enform
Language
HP NonStop SQL/MP Report Writer Guide—527213-001
A-3
Table A-1. Enform Statements
Enform Statements SQLCI With Report Writer
LIST SELECT, DETAIL, and LIST commands
FIND SELECT and LIST commands (1)
CLOSE RESET PARAM command (1)
CANCEL command
DECLARE No user variables, user aggregates, (2) or user tables; can
use aggregates in SELECT command for grouped rows only
DELINK (2)
DICTIONARY VOLUME command (1)
EXIT EXIT command
LINK SELECT...FROM table1, table2,...WHERE
LINK OPTIONAL SELECT...FROM table1 LEFT JOIN table2 ON...
OPEN (2)
PARAM SET PARAM command (set in SQLCI, command interpreter
params passed automatically)
SET SET LAYOUT | STYLE | SESSION | PARAM (no user
variables or user tables)
—parameters allowed in SELECT command only
AT END REPORT FOOTING and TOTAL commands
(only current report)
AT START REPORT TITLE command (current report)
FOOTING
PAGE FOOTING command (current report)
SUBFOOTING (2)
SUBTITLE (2)
TITLE PAGE TITLE command (current report)
1. No comparable feature
2. Provides part of the functionality
Table A-2. Enform Clauses (page 1 of 2)
Enform Clauses SQLCI With Report Writer
AFTER CHANGE BREAK TITLE command
AS, AS DATE, AS TIME AS and AS DATE/TIME clauses (use in print-item)
ASCD and DESC SELECT .. ORDER BY..
AT END PRINT REPORT FOOTING command (no default)
AT START PRINT REPORT TITLE command (no default)