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