SQL/MP Report Writer Guide
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 Introduction to the NonStop SQL/MP Report Writer
- 2 Using SQLCI and the Report Writer
- 3 Selecting Data for a Report
- 4 Customizing a Report
- Defining the Layout
- Specifying the Items in a Detail Line
- Naming Select List and Detail Line Items
- Organizing Rows Into Break Groups
- Labeling Information
- Formatting Data Values
- Formatting Dates and Times
- Using TACL to Pass Parameters
- Conditional Printing of Items or Line Entries
- Redefining Special Characters
- Calculating Totals
- Calculating Subtotals
- Printing Double-Byte Characters
- A Comparison of the Report Writer and the Enform Language
- Index
HP NonStop SQL/MP Report Writer Guide—527213-001
A-1
A
Comparison of the Report Writer and
the Enform Language
The NonStop SQL/MP report writer is used to produce reports based on data from a
NonStop SQL/MP database. Enform is a language that produces reports based on
data from a database that uses Enscribe files. This appendix compares features of the
two report writing tools.
Figure A-1
shows a sample Enform program followed by the SQLCI commands that
produce the same report. There are many similarities between the two methods for
producing reports.
Table A-1
lists Enform statements with the SQLCI and report writer features that you
use to perform similar operations. Table A-2
lists Enform clauses and the
corresponding SQLCI or report writer features. Table A-3
lists Enform option variables
and the corresponding SQLCI or report writer features. Table A-4
lists Enform system
variables. Table A-5
lists Enform commands.