SQL/MP Report Writer Guide

Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-8
T
Special characters (continued)
! commands 2-14
$, inserting in value 4-32
% wild-card character 3-12
* in select list 3-6
=_DEFAULTS DEFINE 2-2
_wild-card character 3-8
SQLCI
ending 2-1
standard prompt 2-6
starting 2-1
user-defined parameters A-7
SQLCI commands, summary of 1-14
Statements, Enform A-3
Stored commands 2-14
Strings
output line, insert in 4-2
print item, insert in 4-24
spacing 4-8
Style options, summary of 1-13
Subqueries
considerations 3-32
IF/THEN/ELSE 4-46
IN predicate 3-9
select list 3-9
using 3-28
SUBTOTAL command 4-54
Subtotals
calculating 4-56
conditional values, on 4-56
description of 1-7
example of 4-53
label for 4-55
with double-byte characters 4-65
SUBTOTAL_LABEL style option 4-65
Subvolume, default 2-1, 2-3
SUM function 3-16
Suppressing
headings 4-16
zero value 4-30, 4-36
SYSTEM command 2-2
System defaults 2-2
System variables, ENFORM A-6
T
TAB clause
using 4-10
with double-byte characters 4-59
Tables
data in 3-2
description of 1-1
joining 3-4
names 3-3
TACL 4-44
Template for display 4-30
Text
creating command file from 2-15
editor, creating a report with 2-15
Time
formatting overview 4-39
local 4-40
Timestamps, converting 4-43
TIME_FORMAT style option 4-41
TMF transaction status 2-3
Top margin 4-3
TOTAL command, using 4-49
Totals
calculating 4-48
conditional values, on 4-56
description of 1-7
example 4-48
Trailing
blanks, comparison of 3-13
zeros 4-1, 4-35
Transaction Management Facility (TMF)
See TMF transaction status
Truncation 4-65