SQL/MX Report Writer Guide

Contents
HP NonStop SQL/MX Report Writer Guide—527194-002
iv
A. Migration from SQL/MP Report Writer to SQL/MX
Report Writer
Formatting Dates and Times 4-42
Date and Time Values 4-42
Julian Timestamp Formats 4-43
SQL/MX Date and Time Formats 4-44
Converting Timestamps 4-45
Formats for Dates Stored as Binary Values 4-46
Conditional Printing of Items or Line Entries 4-46
Redefining Special Characters 4-48
Calculating Totals 4-49
Calculating Subtotals 4-51
Defining a Subtotal Label 4-55
Calculating Subtotals on Conditional Values 4-56
Printing Double-Byte Characters 4-58
A. Migration from SQL/MP Report Writer to SQL/MX Report
Writer
Unsupported Commands, Options, and Functions A-1
Changed Commands and Options A-1
Error Handling A-2
Single and Double Quotes A-2
Index
Figures
Figure i. NonStop SQL/MX Library Map xii
Figure 1-1. Sample Content of Tables 1-2
Figure 1-2. Default Report Layout 1-6
Figure 1-3.
Commands to Produce A Formatted Report 1-10
Figure 1-4.
Formatted Report, page 1 1-11
Figure 1-5. Formatted Report, page 2 1-12
Figure 2-1. Setting and Displaying Options 2-5
Figure 2-2. Listing Rows 2-7
Figure 2-3. Defining a Window Using SET LAYOUT WINDOW 2-8
Figure 2-4. Relation of Window to Output Line 2-10
Figure 2-5. Report Formatting Commands 2-11
Figure 2-6. Repeating Stored Commands 2-15
Figure 3-1. Plan for Report Content 3-3
Figure 3-2. Sample Rows from Joined Tables 3-5
Figure 3-3. Rows Sorted by One Column 3-15
Figure 3-4. Rows Sorted by Two Columns 3-16