SQL/MP Report Writer Guide

Comparison of the Report Writer and the Enform
Language
HP NonStop SQL/MP Report Writer Guide—527213-001
A-6
SQLCI and the report writer provide some features not available in Enform:
•
NAME command Assigns a name to a select list item for use in other commands.
•
CONCAT clause Concatenates print items, optionally stripping trailing blanks.
•
NEED clause Prints lines conditionally depending on space remaining on current
page.
•
VARCHAR_WIDTH option Specifies the maximum number of variable-width
characters to be printed or displayed in a field.
•
LOGICAL_FOLDING option Specifies whether items (in the default DETAIL line)
that do not fit within the margins are split or moved as a whole unit to the next line.
•
WINDOW command Defines a window to view a vertical segment of a report.
•
WRAP option Determines whether output lines that do not fit within the device
width are wrapped or truncated.
Table A-4. Enform System Variables
Enform System Variable SQLCI With Report Writer
@DATE CURRENT_TIMESTAMP or CURRENT function
@TIME CURRENT_TIMESTAMP or CURRENT function
@LINENO LINE_NUMBER function
@PAGENO PAGE_NUMBER function
Table A-5. Enform Commands
Enform Command SQLCI Command
?ASSIGN ADD DEFINE and ALTER DEFINE
?ATTACH (1)
?COMPILE PREPARE (2)
?DICTIONARY VOLUME (2)
?EDIT EDIT and TEDIT
?EXECUTE EXECUTE (2)
?HELP HELP
?OUT OUT_REPORT
?RUN OBEY
?SECTION ?SECTION
?SHOW ENV and SHOW
?SOURCE (1)
(1) No comparable feature
(2) Provides part of the functionality