SQL/MP Report Writer Guide

HP NonStop SQL/MP Report Writer Guide—527213-001
Index-1
Index
A
A (alphanumeric) display descriptor 4-30
Aggregate functions
applied conditionally 3-33
groups of rows 3-15
using 3-16
Aggregates, multilevel and conditional A-7
Alias name 4-13
Alphanumeric comparison 3-11
ALTER DEFINE command 2-2
AND operator 3-13
Arithmetic expression, evaluation of 3-22
Arithmetic operators 3-22
AS clause
display descriptors 4-62
location of 4-32
using 4-37
AS DATE/TIME clause 4-40
Asterisk, in select list 3-32
Averages, computing 3-1
AVG function 3-17
B
BETWEEN predicate 3-7, 3-10
Blanks 3-12
Boolean operators 3-13
Bottom margin 4-3
Break
column subtotaling 1-7
footing 1-7, 4-22
group 1-7, 4-14
title 1-7, 4-21
BREAK FOOTING command 4-24
BREAK ON command 4-14, 4-15
BZ modifier 4-35, 4-36
C
C display descriptor
using 4-37
variable-length values on multiple
lines 4-37
Calculating
groups for 3-15
subtotals 4-51
totals 4-48
CANCEL command 2-6
Canceling formatting commands 2-11
Catalog
creating 3-32
current default 2-3
CHAR data type comparison 3-11
Character set
Tandem Kanji 2-6
, 3-11, 4-58
Tandem KSC5601 2-6, 3-11, 4-58
Character Values
See also String
comparing character values 3-11
display descriptors for 4-30
double-byte, printing 4-58
justification, left or right 1-6, 4-29
redefining special 4-47
Clauses
Enform A-3
report formatting commands 1-12
summary of 1-12
Collations, using 3-11
Columns
data types 3-10
description of 1-11
determining grouping of 3-19
headings 4-16
identifiers 1-11
omitting from output line 4-12