SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Language Elements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
6-20
Comparable and Compatible Data Types
Restrictions for Extended NUMERIC Precision Data Type
The extended NUMERIC precision data type is not supported:
•
On the disk for SQL/MP tables
•
By Module File caching (MFC)
Example for Extended NUMERIC Precision Data Type
>>create table t( n NUMERIC(128,30));
--- SQL operation complete.
>>
>>showddl table t;
CREATE TABLE CAT.SCH.T
(
N NUMERIC(128, 30) DEFAULT NULL
)
.....
.....
.....
.....
;
--- SQL operation complete.
Floating-Point Data
NonStop SQL/MX Release 2.x uses IEEE floating-point format internally and
automatically converts Tandem floating-point formats used in host variables or SQL/MP
tables. However, that conversion can cause rounding errors, or it can fail for extremely
large or extremely small values. Therefore, your programs might experience a
difference in the results compared to previous releases of NonStop SQL/MX.
Applications might not be able to retrieve rows using floating-point values in equal
comparison predicates by using these columns for some floating-point values.
In addition, if you are using an SQL/MP table that contains FLOAT columns (REAL,
DOUBLE PRECISION) with user default values specified, a similarity check for the
table with the compile-time default value might fail for some values, and
NonStop SQL/MX will recompile the query.
For some queries that use the default value, you might not be able to access a float
column with a default value near the boundary value for Tandem float values.
SPACE SQRT STDDEV
SUBSTRING SUM TAN
TANH THIS VARIANCE