User Documentation Ispirer Toolkit Overview Pricing

HP Neoview Data Types - DECIMAL

Versions: HP Neoview 2.4, 2.3 and 2.2

SQL Server - DECIMAL
Syntax DECIMAL[(p[,s])] [SIGNED | UNSIGNED]
Data Fixed-point numeric data stored as ASCII characters
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 ⇐ 18, 0 ⇐ s ⇐ p
Default p is 9, s is 0
Synonym DEC
Standards ANSI SQL

HP Neoview DECIMAL - 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 NUMERIC(p,s)
Floating-point FLOAT(p) REAL DOUBLE PRECISION

All Data Types

Oracle SQL Server IBM DB2 MySQL PostgreSQL Sybase ASE Sybase ASA Informix DS Teradata HP Neoview Interbase/Firebird Ingres