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
Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-9
U
U
UNDERLINE_CHAR style option 4-48
Underscore wild_card character 3-8
UNION operator 4-57
Unnamed parameters 3-24
Uppercase values comparison 3-11
UPSHIFT function 3-11
USA date-time format 4-42
User-defined parameters
in SELECT command 3-24
in SQLCI commands A-1
Using parameters with SELECT
commands 3-23
V
Values, justification of 4-29
VARCHAR data type
comparison of 3-11
display on multiple lines 4-37
VARCHAR date type comparison 3-11
VARCHAR_WIDTH style option 4-37
Variable-length characters 3-13, 4-37
Views, creating 3-1
VOLUME command
saving 2-18
setting defaults with 2-3
Volume, default 2-2, 2-3, 2-18
W
WHERE clause 3-4
Wild-card characters 3-8
WINDOW layout option, using 2-7
Windows defining 2-7
WORK status 2-3
WRAP session option 2-6, 4-59
Z
Zero suppression 4-30, 4-35, 4-36