SQL/MX Report Writer Guide

Index
HP NonStop SQL/MX Report Writer Guide—527194-002
Index-2
D
Columns (continued)
omitting from output line 4-13
qualified names for 3-2
selecting data from 3-5
Command file
defining report in 2-15
Command file, defining report in 2-15
Commands
canceling formatting 2-12
continuation prompt 2-2
entering 2-10
executing again 2-14
executing previous 2-14
repeating 2-14
report formatting 1-14
stored 2-14
Comparison predicate
comparing character values 3-11
comparing uppercase characters 3-11
example of 3-7
operators 3-7
rules 3-12
Compiling SELECT command 3-24
COMPUTE_TIMESTAMP function 4-42
Computing averages 3-1
CONCAT clause 1-15, 4-30, 4-39
Conditional
aggregates 3-34
expressions, not allowed in
parentheses A-1
subtotals, calculating 4-51
Conditions
for display format 4-37
for printing item 4-46
multiple, in a query 3-34
order of evaluation 3-14
selection 3-6
specifying more than one 3-14
Converting timestamps 4-45
CONVERTTIMESTAMP function 4-45
Correlated subqueries 3-29
Correlation name 3-5, 3-30
explicit, example 3-30
explicit, using 3-31
implicit 3-5
implicit, example 3-5
COUNT function 3-19
CREATE CATALOG command 3-32
CREATE VIEW command 3-27
CURRENT function 4-42
CURRENT_TIMESTAMP 4-42
D
Data
formatting 4-30
grouping for calculations 3-16
locating, in database 3-2
organization 1-2
sorting 3-15
source 3-5
Data types
See also individual data types
character, comparing 3-12
formats 4-30
numeric expressions, of A-2
Database
organization 1-2
SQL/MX 1-2
Date
converting 4-45
formatting
European 4-45
overview 4-45
with AS DATE/TIME 4-44
local 4-43
DATEFORMAT function 4-44
Date-time data types 4-42, 4-44
Date-time functions 4-42
DATE_FORMAT style option 4-43
DECIMAL_POINT style option 4-48