SQL/MX 3.2 Report Writer Guide (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Report Writer Guide—691130-001
iv
A. Migration from SQL/MP Report Writer to
SQL/MX Report Writer
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
Figure 3-5. Expressions in the Select List 3-23
Figure 3-6. Expressions in the Detail Line 3-24
Figure 3-7. An Invoice 3-28
Figure 3-8. A Report With a Subquery 3-32