Caché SQL Reference
SQUARE
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

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.
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 }
   }
 
See Also