SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Language Elements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
6-19
Comparable and Compatible Data Types
Considerations for Extended NUMERIC Precision Data Type
•
Supported in all DDL and DML statements where an ordinary NUMERIC data type
is supported.
°
MX tables only
•
Supported from the MXCI, ODBC, JDBC T2 and T4 interfaces.
•
Does not support for host variable declarations in embedded programs.
•
CAST function allows conversion between an ordinary NUMERIC and extended
NUMERIC precision data type.
To convert a signed extended NUMERIC data type to CHAR data type, the
required length of the CHAR host variable is p + 3, where p is the precision of the
extended NUMERIC data type. Three extra bytes are for the sign, decimal point,
and the null terminator. For unsigned extended NUMERIC data type, the required
length is p + 2.
•
Implemented in software (versus hardware for ordinary numeric data type) and
therefore is CPU intensive.
•
Supported in arithmetic operations of addition, subtraction, multiplication, division,
and exponentiation.
°
Supported as a parameter in the following scalar functions:
ABS ACOS ASIN
ATAN ATAN2 AVG
CEILING COS COSH
COUNT DEGREES DIFF1
DIFF2 EXP FLOOR
HASHPARTFUNC INSERT LASTNOTNULL
LEFT LOG LOG10
LPAD MAX MIN
MOVINGAVG MOVINGCOUNT MOVINGMAX
MOVINGMIN MOVINGSTDDEV MOVINGSUM
MOVINGVARIANCE OFFSET POWER
RADIANS REPEAT RIGHT
ROWS SINCE RPAD RUNNINGAVG
RUNNINGCOUNT RUNNINGMAX RUNNINGMIN
RUNNINGSTDDEV RUNNINGSUM RUNNINGVARIANCE
SIGN SIN SINH