SQL/MX Report Writer Guide

Index
HP NonStop SQL/MX Report Writer Guide—527194-002
Index-6
P
Operators
arithmetic 3-23
Boolean 3-7
comparison 3-7
Options
layout, definition 2-5
setting and displaying 2-5
style, definition 2-5
OR operator 3-7
Order
arithmetic evaluation 3-23
condition evaluation 3-14
select list 3-17
ORDER BY clause
break groups, relation to 4-15
description of 3-17
example 1-6
row grouping 3-17
Outer query 3-30
OUT_REPORT A-1
Overflow character, single item 4-33
OVERFLOW_CHAR style option 4-40
P
Page
breaks 4-6
fitting lines on 4-6, 4-21
footing 1-8, 4-6
length 4-6
length, setting 1-7
numbering 4-6
title 4-20
PAGE clause 4-6
PAGE FOOTING command 4-25
PAGE TITLE command 4-20
PAGE_COUNT 1-5
PAGE_LENGTH layout option 4-6
PAGE_NUMBER function 4-7
Pagination 4-1, 4-6
Parameters
named 3-24
unnamed 3-26
user-defined in SELECT
command 3-24
Parentheses in expressions 3-14
Percent of all row values 3-35
PIC X data type comparison 3-12
Predicates 3-7
PREPARE command 3-25
Print items
conditional printing 4-13
description of 1-13
field size 4-19
filler characters 4-1
formatting 4-30, 4-45
print lists 1-14
spaces between 4-10
Printing reports
using a LOG file A-1
with formatting commands 2-13
Prompt
command continuation prompt 2-2
MXCI standard prompt 2-2, 2-6
select-in-progress prompt 2-2
Proper names, formatting 4-14, 4-39
Q
Qualified column name 3-2
Quantified predicates
comparison operators and 3-7
example of 3-30
Queries
See also SELECT command
developing 3-1
multistep 3-32
Quotation marks, rules for using A-2