SQL/MP Report Writer Guide

Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-6
P
Organization of data 1-1
Orphans 4-4
OUT file, displaying current 2-12
Outer query 3-29
Output device width 2-3
OUT_REPORT command 2-21
OUT_REPORT file
content of 2-13
displaying current 2-2
specifying 1-4
Overflow character, single item 4-31
OVERFLOW_CHAR style option 4-38
P
Page
breaks 4-4
fitting lines on 4-5, 4-20
footing 1-7, 4-5
length 4-5
numbering 4-5
title 4-18
PAGE clause 4-5
PAGE FOOTING command 4-23
PAGE TITLE command 4-19
Pages
footing 1-7
PAGE_LENGTH layout option 4-5
PAGE_NUMBER function 4-5
Parameters
named 3-23
passing to report command 4-44
unnamed 3-25
user-defined in SELECT
command 3-23
user-defined in SQLCI commands A-7
Parentheses in expressions 3-13
Percent of all row values 3-35
Percent (%) wild-card character 3-8
PIC X data type comparison 3-11
Predicates 3-7
PREPARE command 3-24
Previous commands 2-14
Print items
conditional printing 4-12
description of 1-11
field size 4-17
filler characters 4-1
formatting 4-28, 4-43
print lists 1-11
spaces between 4-9
tab position for 4-10
Printing reports
using OUT_REPORT command 2-18
with formatting commands 2-12
Prompts 2-3
Proper names, formatting 4-13, 4-36
Q
Qualified
column name 3-2
table name 3-4
Quantified predicates
comparison operators and 3-7
example of 3-30
Queries
See also Select command
developing 3-1
multistep 3-32, A-4
R
Repeating commands 2-14
Replacing commands 2-11
REPORT FOOTING command 4-23
Report formatting clauses 1-12
Report formatting commands, summary
of 1-12
See also Commands
Report functions
summary of 1-14