SQL/MX Comparison Guide for SQL/MP Users

Index
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
Index-6
Q
Program invalidation 2-13
PROGRAMS table 2-13
Protection view 2-13
PURGE command 2-13
PURGEDATA command 2-13
Q
Qualified fileset list 2-13
Quantified predicate 2-13
Query caching
cache location 3-24
considerations 3-24
controls 3-24
counter 3-26
description of 3-24
efficiency increase 3-24
setting 3-24
size limit 3-24
statistics 3-25
types of queries 3-26
Query expressions 3-15
Query type comparison 3-27
Queues 5-5
R
READ UNCOMMITTED access, compared
to BROWSE access 3-16
RECLENGTH file attribute 2-13
Regular identifiers 3-5
RELEASE statement 2-13
REPORT FOOTING command 2-13
REPORT option 2-13
REPORT TITLE command 2-13
Report Writer 1-3
Report Writer commands
AS clause 2-2
AS DATE/TIME clause 2-2
BREAK FOOTING command 2-2
BREAK ON command 2-2
BREAK TITLE command 2-2
Report Writer commands (continued)
CANCEL command 2-2
CENTER_REPORT option 2-3
CONCAT clause 2-3
DATE_FORMAT option 2-5
DECIMAL_POINT option 2-6
DETAIL command 2-6
HEADINGS option 2-8
IF/THEN/ELSE clause 2-9
LEFT_MARGIN option 2-10
LINE_NUMBER function 2-10
LINE_SPACING option 2-10
LIST command 2-10
LOGICAL_FOLDING option 2-10
NAME command 2-11
NEWLINE_CHAR option 2-11
NULL_DISPLAY 2-11
OUT_REPORT command 2-12
OVERFLOW_CHAR command 2-12
PAGE TITLE option 2-12
PAGE_COUNT option 2-12
PAGE_FOOTING option 2-12
PAGE_LENGTH option 2-12
PAGE_NUMBER option 2-12
REPORT FOOTING command 2-13
REPORT TITLE command 2-13
RESET LAYOUT command 2-13
RESET REPORT command 2-13
RESET SESSION command 2-13
RESET STYLE command 2-13
RIGHT_MARGIN option 2-13
ROWCOUNT option 2-13
SET LAYOUT command 2-14
SET PARAM command 2-14
SET STYLE command 2-14
SHOW LAYOUT command 2-14
SHOW REPORT command 2-14
SHOW SESSION command 2-14
SHOW STYLE command 2-14