SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-27
S
Sequence functions (continued)
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-122
RUNNINGAVG 9-126
RUNNINGCOUNT 9-128
RUNNINGMAX 9-130
RUNNINGMIN 9-132
RUNNINGSTDDEV 9-134
RUNNINGSUM 9-136
RUNNINGVARIANCE 9-138
THIS 9-156
SERIALIZABLE 1-6, 1-9
SESSION_USER function
examples of 9-141
syntax diagram of 9-141
SET CATALOG 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, 2-215
SET DESCRIPTOR statement
C examples of 3-85
COBOL examples of 3-86
syntax diagram of 3-79
Set functions 9-1
SET LIST_COUNT command
examples of 4-46
syntax diagram of 4-46
SET MPLOC statement
examples of 2-214
scope of 2-214
SET MPLOC statement (continued)
syntax diagram of 2-214
SET NAMETYPE statement
examples of 2-215
scope of 2-215
SET ON ROLLBACK clause
DELETE description of 2-112
UPDATE description of 2-234
SET PARAM command
examples of 4-48
syntax diagram of 4-47
SET SCHEMA statement
C examples of 2-217
COBOL examples of 2-217
MXCI examples of 2-217
scope of 2-216
syntax diagram of 2-216
SET SHOWSHAPE command
default setting 4-50
examples of 4-51
syntax diagram of 4-50
SET statement
considerations 2-211
syntax diagram of 2-211
SET STATISTICS command
default setting 4-53
examples of 4-53
syntax diagram of 4-53
SET TABLE TIMEOUT statement
C examples of 2-221
MXCI examples of 2-221
syntax diagram of 2-218
SET TERMINAL_CHARSET command
syntax diagram of 4-54
SET TRANSACTION statement
C examples of 2-226
COBOL examples of 2-226
MXCI examples of 2-226
syntax diagram of 2-223
transaction modes set by 2-223