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
Comparison of the Report Writer and the Enform
Language
HP NonStop SQL/MP Report Writer Guide—527213-001
A-5
Table A-3. Enform Option Variables
Enform Option Variable SQLCI With Report Writer
@BLANK-WHEN-ZERO AS clause with BZ modifier (2)
@BREAK-KEY SET SESSION BREAK_KEY command
@CENTER-PAGE CENTER_REPORT layout option
@COPIES OUT_REPORT..SPOOL3 option
@COST-TOLERANCE (1)
@DATE-FORMAT DATE_FORMAT style option
@DECIMAL DECIMAL_POINT style option
@DISPLAY-COUNT LIST_COUNT session option
@HEADING HEADINGS style option
@LINES PAGE_LENGTH layout option
@MARGIN LEFT_MARGIN layout option
@NEWLINE NEWLINE_CHAR style option
@NONPRINT-REPLACE (1)
@OVERFLOW OVERFLOW_CHAR and TRUNCATE style options
@PAGES PAGE_COUNT layout option
@PRIMARY-EXTENT-
SIZE
(1)
@READS (1)
@SECONDARY-EXTENT-
SIZE
(1)
@SPACE SPACE layout option
@STATS DISPLAY STATISTICS and STATISTICS option (2)
@SUBTOTAL-LABEL SUBTOTAL_LABEL style option
@SUMMARY-ONLY Only by SELECT ...GROUP BY with aggregate functions in
the select list
@TARGET-RECORDS (1)
@TIME-FORMAT TIME_FORMAT style option
@UNDERLINE UNDERLINE_CHAR style option
@VSPACE LINE_SPACING layout option
@WARN WARNINGS session option
@WIDTH RIGHT_MARGIN style option
(1) No comparable feature
(2) Provides part of the functionality