SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xli
8. SQL/MX Functions and Expressions
SECOND Function 8-167
Examples of SECOND 8-167
SESSION_USER Function 8-168
Examples of SESSION_USER 8-168
SIGN Function 8-168
Examples of SIGN 8-168
SIN Function 8-169
Examples of SIN 8-169
SINH Function 8-169
Examples of SINH 8-169
SPACE Function 8-170
Examples of SPACE 8-170
SQRT Function 8-170
Examples of SQRT 8-170
STDDEV Function 8-171
Considerations for STDDEV 8-171
Definition of STDDEV 8-171
Data Type of the Result 8-172
Operands of the Expression 8-172
Nulls 8-172
FLOAT(54) and DOUBLE PRECISION Data 8-172
Examples of STDDEV 8-172
SUBSTRING Function 8-174
Considerations for SUBSTRING 8-174
Requirements for the Expression, Length, and Start Position 8-174
Examples of SUBSTRING 8-175
SUM Function
8-176
Considerations for SUM 8-176
Data Type and Scale of the Result 8-176
Operands of the Expression
8-176
Examples of SUM
8-177
TAN Function 8-178
Examples of TAN
8-178
TANH Function
8-178
Examples of TANH
8-178
THIS Function
8-179
Considerations for THIS 8-179
Counting the Rows
8-179
Example of THIS 8-179