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

SQL/MX Functions and Expressions

HP NonStop SQL/MX Reference Manual—540440-003

9-10

ABS Function

The ABS function returns the absolute value of a numeric value expression.

ABS is an SQL/MX extension.

numeric-expression

is an SQL numeric value expression that specifies the value for the argument of

the ABS function. The result is returned as an unsigned numeric value if the

precision of the argument is less than 10 or as a LARGEINT if the precision of the

argument is greater than or equal to 10. See Numeric Value Expressions on

page 6-48.

Examples of ABS

•

This function returns the value 8:

ABS (-20 + 12)

ACOS Function

The ACOS function returns the arccosine of a numeric value expression as an angle

expressed in radians.

ACOS is an SQL/MX extension.

numeric-expression

is an SQL numeric value expression that specifies the value for the argument of

the ACOS function. The range for the value of the argument is from -1 to +1. See

Numeric Value Expressions on page 6-48.

Examples of ACOS

•

This function returns the value 3.49044274380724352E-001 or approximately

0.3491 in radians (which is 20 degrees):

ACOS (0.9397)

•

This function returns the value 0.3491. The function ACOS is the inverse of the

function COS.

ACOS (COS (0.3491))

ABS (numeric-expression)

ACOS (numeric-expression)