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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxxix
8. SQL/MX Functions and Expressions
MOVINGSUM Function 8-119
Examples of MOVINGSUM 8-120
MOVINGVARIANCE Function 8-121
Examples of MOVINGVARIANCE 8-122
NVL Function 8-123
Considerations 8-123
Example of NVL 8-124
NVL2 Function 8-125
Considerations 8-125
Examples of NVL2 8-125
OCTET_LENGTH Function 8-126
Considerations for OCTET_LENGTH 8-126
CHAR and VARCHAR Operands 8-126
Similarity to CHAR_LENGTH Function 8-126
Examples of OCTET_LENGTH 8-127
OFFSET Function 8-128
Examples of OFFSET 8-128
PI Function 8-130
Examples of PI 8-130
POSITION Function 8-131
Considerations for POSITION 8-131
Result of POSITION 8-131
Using the UPSHIFT Function 8-131
Examples of POSITION 8-132
POWER Function 8-132
Examples of POWER 8-132
QUARTER Function
8-133
Examples of QUARTER 8-133
QUERYCACHE Function 8-134
Considerations for QUERYCACHE
8-134
Using QUERYCACHE and DISPLAY_QC
8-134
Result of the QUERYCACHE Function 8-134
Examples of QUERYCACHE
8-136
QUERYCACHEENTRIES Function
8-138
Considerations for QUERYCACHEENTRIES
8-138
Using QUERYCACHEENTRIES and DISPLAY_QC_ENTRIES
8-138
Result of the QUERYCACHEENTRIES Function 8-139
Examples of QUERYCACHEENTRIES
8-140
RADIANS Function 8-143