Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Trigonometric FunctionsThe built-in trigonometric functions calculate ratios of the lengths of the sides of right triangles. Two supporting functions, DEGREES and RADIANS, can respectively convert the units of angular values from radians to degrees, and from degrees to radians.
ATAN2 FunctionThe ATAN2 function computes the angular component of the polar coordinates (r, q) associated with (x, y).

ATAN2 Function

The ATAN2 function computes the angular component of the polar coordinates (r, q) associated with (x, y).

The following example compares angles to q for the rectangular coordinates (4, 5):

WHERE angles > ATAN2(4,5)     --determines q for (4,5) and
                                --compares to angles

You can determine the length of the radial coordinate r using the expression that the following example shows:

SQRT(POW(x,2) + POW(y,2))     --determines r for (x,y)

You can determine the length of the radial coordinate r for the rectangular coordinates (4,5) using the expression that the following example shows:

SQRT(POW(4,2) + POW(5,2))     --determines r for (4,5)