SQL/MX Report Writer Guide

HP NonStop SQL/MX Report Writer Guide—527194-002
Index-1
Index
A
A display descriptor 4-33
ADD DEFINE command A-1
Aggregate functions
applied conditionally 3-33
groups of rows 3-16
using 3-17
Alias name 4-14
Alphanumeric character comparison 3-11
Ampersand A-1
AND operator 3-14
Arithmetic expression, evaluation of 3-23
Arithmetic operators 3-23
AS clause
formatting Julian timestamp 4-43
in DETAIL command 4-34
Julian timestamp data type
requirement 4-44
overview 4-32
Averages, computing 3-1
AVG function 3-18
B
BETWEEN
comparing a set of columns 3-10
one parameter allowed A-1
overview 3-8
Blanks
trailing 3-12
blanks
padding with 4-47
trailing 4-41
trailing, with CHAR data type 4-41
blanks, padding with 4-47
Blanks, trailing 3-13
using to compare characters 3-13
Boolean operators 3-14
Break
column subtotaling 1-8
footing 1-8, 4-24
group 1-8, 4-15
title 1-8, 4-22
BREAK FOOTING command 4-26
BREAK ON command 4-15, 4-16
BZ modifier 4-38, 4-39
C
CANCEL command 2-7
Catalog, creating 3-32
CENTER_REPORT 1-16
CHAR data type comparison 3-12
Characters
comparing character data types 3-12
comparing character values 3-11
comparing lowercase 3-11
comparing uppercase 3-11
display descriptors for 4-33
double-byte, printing 4-58
justification 1-7, 4-32
maximum in a line 1-16
redefining special characters 4-48
VARCHAR data type comparison 3-12
variable-length 3-13
Clauses
report formatting commands 1-14
report formatting, summary of 1-15
CN[.m] display descriptor A-1
Collations, using 3-11
Columns
data types 3-10
description of 1-13
determining grouping of 3-20
headings 4-17
identifiers 1-13