SQL/MX Report Writer Guide

Index
HP NonStop SQL/MX Report Writer Guide—527194-002
Index-4
F
F
F display descriptor
example 4-34
using 4-34
zero suppression 4-38
FC command 4-55
Field filler characters 4-1, 4-40
Field size 4-19
File
See Command file
Fitting lines on a page 4-6, 4-21
Fixed-point display 4-33
FL modifier 4-40
Folding a line 2-7
Footings
break 1-8, 4-24
page 1-8
Format of data types 4-30
Formatting clauses, summary of 1-14
Formatting commands
canceling 2-12
summary of 1-14
FROM clause 3-4
Functions, summary of report 1-17
G
GROUP BY clause
computing sums or averages with 3-18
select list relation 3-17
Grouping columns
choosing 3-21
select list relation 3-17
Guardian timestamp
See Julian timestamp
H
Headings
multiple-line 4-19
suppressing 4-17
I
I display descriptor
overview 4-33
using 4-35
zero suppression with 4-38
IF/THEN/ELSE clause
subtotaling, substitute method 4-56
using 4-46
IN predicate 3-9
Integer display 4-33
INTERVAL data type, totaling 4-51
Invoice example 3-28
INVOKE command 3-2
Items,naming with an alias 4-14
J
Julian timestamp 4-42
JULIANTIMESTAMP function 4-44
Justification of values 4-32
L
Layout options
CENTER_REPORT 1-16
definition 1-3
LOGICAL_FOLDING 2-7, A-2
PAGE_COUNT 1-5
PAGE_LENGTH 4-6
summary of 1-16
using 4-2
LIKE predicate
comparison operators 3-7
using 3-12
Lines
folding 2-7
heading 4-19
inserting text in 4-30
keeping together on page 4-6
logical 1-13
maximum length 1-16