SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-28
S
SELECT statement (continued)
syntax diagram of 2-197
table reference within 2-202
TRANSPOSE clause 2-209
union operation within 2-212, 2-218
views and 2-214
WHERE clause 2-208
SELECT statement (embedded)
C examples of 2-227
COBOL examples of 2-228
INTO clause 2-201
syntax diagram of 2-197
table reference within 2-201
SEQUENCE BY clause
examples of 7-20
SELECT statement use of 7-18
syntax diagram of 7-18
Sequence functions
summary of 9-7
DIFF1 9-48
DIFF2 9-51
LASTNOTNULL 9-72
MOVINGAVG 9-91
MOVINGCOUNT 9-93
MOVINGMAX 9-95
MOVINGMIN 9-97
MOVINGSTDDEV 9-99
MOVINGSUM 9-101
MOVINGVARIANCE 9-103
OFFSET 9-106
ROWS SINCE 9-124
RUNNINGAVG 9-128
RUNNINGCOUNT 9-130
RUNNINGMAX 9-132
RUNNINGMIN 9-134
RUNNINGSTDDEV 9-136
RUNNINGSUM 9-138
RUNNINGVARIANCE 9-140
THIS 9-154
SERIALIZABLE 1-8, 1-10, 1-22
SESSION_USER function
examples of 9-143
syntax diagram of 9-143
SET CATALOG statement
C examples of 2-232
COBOL examples of 2-232
MXCI examples of 2-231
scope of 2-231
syntax diagram of 2-231, 2-234
SET DESCRIPTOR statement
C examples of 3-84
COBOL examples of 3-85
syntax diagram of 3-78
Set functions 9-1
SET LIST_COUNT command
examples of 4-50
syntax diagram of 4-50
SET MPLOC statement
examples of 2-233
scope of 2-233
syntax diagram of 2-233
SET NAMETYPE statement
examples of 2-234
scope of 2-234
SET ON ROLLBACK clause
DELETE description of 2-116
UPDATE description of 2-253
SET PARAM command
examples of 4-52
syntax diagram of 4-51
SET SCHEMA statement
C examples of 2-236
COBOL examples of 2-236
MXCI examples of 2-236
scope of 2-235
syntax diagram of 2-235
SET SHOWSHAPE command
default setting 4-54
examples of 4-55