Ispirer Website Ispirer Toolkit Overview Free Trial

HP Neoview Data Types - NUMERIC

Versions: HP Neoview 2.4, 2.3 and 2.2

SQL Server - NUMERIC
Syntax NUMERIC[(p[,s])] [SIGNED | UNSIGNED]
Data Fixed-point numeric data
Parameters p is the maximum number of all digits (both sides of the decimal point), s is the maximum number of digits after the decimal point
Range 1 ⇐ p ⇐ 128, 0 ⇐ s ⇐ p
Default p is 9, s is 0
Notes Neoview also supports extended NUMERIC data type with no limits on precision. This is a software type, all operations are performed by software, not hardware CPU
Standards ANSI SQL

HP Neoview NUMERIC - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(p,s), 1 ⇐ p ⇐ 38, -84 ⇐ s ⇐ 127
SQL Server DECIMAL(p,s,), NUMERIC(p,s), 1 ⇐ p ⇐ 38, 0 ⇐ s ⇐ p
MySQL DECIMAL(p,s,), NUMERIC(p,s), 1 ⇐ p ⇐ 65, 0 ⇐ s ⇐ 30
PostgreSQL DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 1000, 0 ⇐ s ⇐ p
Sybase ASE DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 38, 0 ⇐ s ⇐ p
Informix DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 32, 0 ⇐ s ⇐ p
Ingres DECIMAL(p,s), NUMERIC(p,s), 1 ⇐ p ⇐ 39, 0 ⇐ s ⇐ p

Related Data Types in HP Neoview

Data Types
Integers LARGEINT INT SMALLINT
Fixed-point DECIMAL(p,s)
Floating-point FLOAT(p) REAL DOUBLE PRECISION

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.