SQL/MX Report Writer Guide

Index
HP NonStop SQL/MX Report Writer Guide—527194-002
Index-7
R
R
Replacing commands 2-12
REPORT FOOTING command 4-25
Report formatting
clauses, summary of 1-15
commands, summary of 1-14
Report functions
summary of 1-17
using 3-24
Reports
customized 1-8
date and time, current 3-2
defining 2-15
development steps 1-4
footing 1-8, 4-24
formatted 1-8
formatted, example 1-8
functions summary 1-17
layout and style 1-5
printing as LOG file A-1
saving 2-16
subquery used with 3-30
title 1-8
RESET command 2-5
RESET LAYOUT command 2-6
RESET REPORT A-1
RESET REPORT SELECT A-1
RESET REPORT TOTAL A-2
RESET SESSION A-1
RESET STYLE command 2-6
Rows
averaging 3-16
break groups 4-1, 4-15
counting 3-18
description of 1-2
functions applied to groups of 3-33
grouping for calculations 3-16
listing 2-6
maximum value 3-19
Rows (continued)
minimum value 3-19
returning to the first 2-6
selecting distinct 3-21
sorting 3-1
summing 3-16
value as percent of all rows 3-35
S
Scale factor for display value,
specifying 4-34
Scale-sign descriptors 4-33
Search conditions
Boolean operators for 3-7
IF/THEN/ELSE clause 4-47
multiple 3-9
SELECT command
canceling 2-6, 2-7
compiling 3-24
first row, returning to 2-13
parameters in select list 3-24
preparing 3-25
Select list
asterisk (*) 3-32
DISTINCT keyword 3-21
expressions in 3-22
GROUP BY clause relation 3-17
naming items in 4-14
omitting from output line 4-13
order 3-6
subquery 3-9
Selection criteria 3-1
Select-in-progress prompt 2-2
Session environment 2-1
SET LAYOUT command 1-3
SET PARAM command 3-25
SET SESSION A-1
SET STYLE command 1-3
Setting margins 4-2