SQL/MX 3.x Reference Manual (H06.22+, J06.11+)
Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-29
S
Sequence functions (continued)
DIFF2 9-51
LASTNOTNULL 9-74
MOVINGAVG 9-95
MOVINGCOUNT 9-97
MOVINGMAX 9-99
MOVINGMIN 9-101
MOVINGSTDDEV 9-103
MOVINGSUM 9-105
MOVINGVARIANCE 9-107
OFFSET 9-110
ROWS SINCE 9-130
RUNNINGAVG 9-135
RUNNINGCOUNT 9-137
RUNNINGMAX 9-139
RUNNINGMIN 9-141
RUNNINGSTDDEV 9-143
RUNNINGSUM 9-145
RUNNINGVARIANCE 9-147
THIS 9-161
SERIALIZABLE 1-8, 1-10, 1-22
SESSION_USER function
examples of 9-150
syntax diagram of 9-150
SET CATALOG statement
C examples of 2-235
COBOL examples of 2-235
MXCI examples of 2-234
scope of 2-234
syntax diagram of 2-234, 2-237
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-61
syntax diagram of 4-61
SET MPLOC statement
examples of 2-236
scope of 2-236
syntax diagram of 2-236
SET NAMETYPE statement
examples of 2-237
scope of 2-237
SET ON ROLLBACK clause
DELETE description of 2-117
UPDATE description of 2-256
SET PARAM command
examples of 4-63
syntax diagram of 4-62
SET SCHEMA statement
C examples of 2-239
COBOL examples of 2-239
MXCI examples of 2-239
scope of 2-238
syntax diagram of 2-238
SET SHOWSHAPE command
default setting 4-65
examples of 4-66
syntax diagram of 4-65
SET statement
considerations 2-233
syntax diagram of 2-233
SET STATISTICS command
default setting 4-68
examples of 4-68
syntax diagram of 4-68
SET TABLE TIMEOUT statement
C examples of 2-243
MXCI examples of 2-242
syntax diagram of 2-240
SET TERMINAL_CHARSET command
syntax diagram of 4-69
SET TRANSACTION statement
C examples of 2-248
COBOL examples of 2-248
MXCI examples of 2-248










