SQL/MX Report Writer Guide

Index
HP NonStop SQL/MX Report Writer Guide—527194-002
Index-8
T
SHOW LAYOUT
definition 1-17
example 4-2
Single spacing 2-6, 4-10
SKIP clause 4-10
Sorting data 3-1
Source data 3-5
SPACE clause 4-11
SPACE layout option 4-10
Spacing
double 4-10
items 4-1
line 4-1
of items and lines 4-11
single 4-10
Special characters
redefining 4-48
! 1-5
$, inserting in value 4-35
Stored commands 2-14
Strings
output line, insert in 4-2
spacing 4-10
Style options
definition 1-3
summary of 1-15
Subqueries
considerations 3-32
IF/THEN/ELSE 4-46
IN predicate 3-9
in report writer commands A-2
nested 3-32
select list 3-10
using 3-28
SUBTOTAL command 4-54
Subtotals
calculating 4-51, 4-56
conditional values, on 4-56
description of 1-8
example of 4-53
Subtotals (continued)
label for 4-55
SUM function 3-17, 3-18
Suppressing
headings 4-17
zero value 4-33, 4-38, 4-39
T
TAB clause
using 4-11
Tables
data in 3-2
description of 1-2
joining 3-4, 3-9
names 3-4
qualified name 2-2
SQL/MP 1-1
Template for display mask 4-33
Text
creating command file from 2-15
editor, creating a report with 2-15
Time
formatting overview 4-42
local 4-43
Timestamps, converting 4-45
to print name of month 4-45
TIME_FORMAT style option 4-43
TMF transaction status 2-3
TOTAL command, using 4-49
Totals
calculating 4-49
conditional values, on 4-56
description of 1-8
example 4-49
Trailing
blanks 3-12
zeros 4-38