Skip to main content
Previous section   Next section

SQUARE

A scalar numeric function that returns the square of a number.

Synopsis

SQUARE(numeric-expression)

Arguments

Argument Description
numeric-expression An expression that resolves to a numeric value.

Description

SQUARE returns the square of numeric-expression. SQUARE returns NULL if passed a NULL value.

The precision and scale returned by SQUARE are the same as those returned by the SQL multiplication operator.

Examples

The following Embedded SQL example returns the squares of the integers 0 through 10:

   SET a=0
   WHILE a<11 {
   &sql(SELECT SQUARE(:a) INTO :b)
   IF SQLCODE'=0 {
     WRITE !,"Error code ",SQLCODE
     QUIT }
   ELSE {
     WRITE !,"The square of ",a," = ",b
     SET a=a+1 }
   }
Copy code to clipboard

See Also

Previous section SQRT    STRNext section