Skip to main content
Previous sectionNext section

SQUARE

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

Synopsis

SQUARE(numeric-expression)

Arguments

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

SQUARE returns either the NUMERIC or DOUBLE data type. If numeric-expression is data type DOUBLE, SQUARE returns DOUBLE; otherwise, it returns NUMERIC.

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