SQL/MP Report Writer Guide

Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-2
D
Columns (continued)
qualified names for 3-2
selecting data from 3-5
Command file
creating from log file 2-20
creating text from data with 2-20
defining report in 2-15
saving report in 2-17
Commands
continuation prompt 2-1
displaying previous 2-19
Enform A-6
entering 2-10
formatting, canceling 2-11
reexecuting 2-14
report formatting 1-12
stored 2-14
Comparing character values 3-11
Comparing uppercase values 3-11
Comparison predicate
example of 3-7
operators 3-7
rules 3-12
Compiling SELECT command 3-23
COMPUTE_TIMESTAMP function 4-40
Computing averages 3-1
CONCAT clause 1-12, 4-28, 4-36
Condition
For display format 4-34
for printing item 4-46
multiples of 3-34
order of evaluation of 3-13
selection 3-6
specifying more than one 3-13
Conditional
aggregates 3-34
, A-7
subtotals, calculating 4-51
Converting timestamps 4-43
CONVERTTIMESTAMP function 4-43
Correlated subqueries 3-28
Correlation name, explicit and implicit 3-30
COUNT function 3-18
CREATE CATALOG command 3-32
CREATE VIEW command 3-26
Creating a report with a text editor 2-13
CURRENT function 4-40
CURRENT_TIMESTAMP 4-39, 4-40
Customized report 1-6
D
Data
formatting 4-28
grouping for calculations 3-15
locating 3-2
organization 1-1
sorting 3-14
source 3-5
type of table column 4-28
Database example 1-1
Date
converting 4-43
formatting overview 4-42
local 4-40
NUMERIC data type, formatting 4-42
DATEFORMAT function 4-42
Date-time data types 4-39, 4-42
Date-time functions 4-40
DATE_FORMAT style option 4-41
Day of week, name of 4-43
Decimal character 4-48
DECIMAL_POINT style option 4-48
Decorations
display of 4-30
form of 4-34
Defaults
catalog 2-3
date and time formats 4-41
decimal character 4-48
heading 4-12
overflow character 4-31