SQL/MP Report Writer Guide

Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-7
S
Report functions (continued)
using 3-23
REPORT TITLE command 4-45
Reports
creating with text editor 2-13
defining 2-15
development steps 1-3
Enform A-1
footing 1-7, 4-22
functions summary 1-14
layout and style 1-4
saving 2-16
section 2-17
subquery used with 3-30
title 1-6
RESET command 2-3
RESET LAYOUT command 2-4
RESET STYLE command 2-4
RIGHT_MARGIN layout option 4-59
Rows
averaging 3-15
break groups 4-1, 4-14
counting 3-17
description of 1-1
functions applied to groups of 3-33
grouping for calculations 3-15
listing 2-5
maximum value 3-18
minimum value 3-18
returning to the first 2-5
selecting distinct 3-20
sorting 3-1
summing 3-15
value as percent of all rows 3-35
S
Sample
default report 1-5
formatted report 1-7
SAVE command 2-13
Scale factor for display value,
specifying 4-32
Scale-sign descriptors 4-30
Search condition
Boolean operators for 3-7
IF/THEN/ELSE clause 4-46
Section of report 2-17
SELECT command
canceling 2-5
, 2-6
compiling 3-23
first row, returning to 2-12
parameters in select list 3-23
preparing 3-24
Select list
asterisks 3-32
DISTINCT keyword 3-20
expressions in 3-21
GROUP BY clause relation 3-16
naming items in 4-13
omitting from output line 4-12
order 3-6
subquery 3-9
Selection criteria 3-1
Select-in-progress prompt 2-1
Session environment 2-1
Session options, saving in file 2-17
SET LAYOUT command 1-3
SET PARAM command 3-24
SET STYLE command 1-3
Setting margins 4-1
Significance of blanks 3-12
Single spacing 2-4, 4-9
SKIP clause 4-9
Sorting data 3-1
Source data 3-5
SPACE clause 4-10
SPACE layout option 4-9
Spacing of items and lines 4-10
Special characters
redefining 4-47