SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-28
S
SELECT statement
(embedded) (continued)
syntax diagram of 2-174
table reference within 2-178
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-45
DIFF2 9-48
LASTNOTNULL 9-68
MOVINGAVG 9-87
MOVINGCOUNT 9-89
MOVINGMAX 9-91
MOVINGMIN 9-93
MOVINGSTDDEV 9-95
MOVINGSUM 9-97
MOVINGVARIANCE 9-99
OFFSET 9-102
ROWS SINCE 9-120
RUNNINGAVG 9-124
RUNNINGCOUNT 9-126
RUNNINGMAX 9-128
RUNNINGMIN 9-130
RUNNINGSTDDEV 9-132
RUNNINGSUM 9-134
RUNNINGVARIANCE 9-136
THIS 9-150
SERIALIZABLE 1-8, 1-10, 1-22
SESSION_USER function
examples of 9-139
syntax diagram of 9-139
SET CATALOG statement
C examples of 2-209
COBOL examples of 2-209
MXCI examples of 2-208
scope of 2-208
syntax diagram of 2-208, 2-211
SET DESCRIPTOR statement
C examples of 3-83
COBOL examples of 3-84
syntax diagram of 3-77
Set functions 9-1
SET LIST_COUNT command
examples of 4-46
syntax diagram of 4-46
SET MPLOC statement
examples of 2-210
scope of 2-210
syntax diagram of 2-210
SET NAMETYPE statement
examples of 2-211
scope of 2-211
SET ON ROLLBACK clause
DELETE description of 2-110
UPDATE description of 2-229
SET PARAM command
examples of 4-48
syntax diagram of 4-47
SET SCHEMA statement
C examples of 2-213
COBOL examples of 2-213
MXCI examples of 2-213
scope of 2-212
syntax diagram of 2-212
SET SHOWSHAPE command
default setting 4-50
examples of 4-51
syntax diagram of 4-50
SET statement
considerations 2-207
syntax diagram of 2-207
SET STATISTICS command
default setting 4-53
examples of 4-53
syntax diagram of 4-53
SET TABLE TIMEOUT statement
C examples of 2-217