HP 3000 Manuals HP 3000 Manuals
More Type Support in HP ALLBASE/BRW
by Kathryn Andersen
Application Support Division/STC
HP ALLBASE/BRW now supports HP ALLBASE/SQL datatypes DATE and TIME. This
enhancement appears in HP ALLBASE/BRW (version A.01.10), which runs on XL
releases in native mode. Note that the compatibility mode version HP
BRW/V does not support HP ALLBASE/SQL.
Four System Functions have been added to HP ALLBASE/BRW, called
TO_INTEGER, TO_REAL, TO_NUMERIC and TO_STRING, for explicitly converting
to and from Integer, Real, Numeric and String types. This enhancement
appears in HP ALLBASE/BRW (version A.01.10), which runs on XL releases in
native mode. The compatibility mode version HP BRW/V has the version
number A.02.30.
The new functions can be used in conditions and Calculated Items, and are
entered as indicated below:
Syntax
TO_INTEGER( expression)
TO_REAL( expression)
TO_NUMERIC( expression)
TO_STRING( expression)
The TO_INTEGER function converts the expression to an integer.
The TO_REAL function converts the expression to a real value.
The TO_NUMERIC function converts the expression to a numeric value.
The TO_STRING function converts the expression to a string value.
These functions are valid for integer, real, numeric, and string
expressions.