Data Integration-Free and PayGo
- Data Integration-Free and PayGo
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Netezza Datatype
| Range
| Transformation Datatype
| Range
|
|---|---|---|---|
BigInt
| Precision 19, scale 0
| Bigint
| From -9,223,372,036,854,775,808 through 9,223,372,036,854,775,807
Precision of 19, scale of 0 Integer value
|
Bool
| True or false, on or off, 0 or 1, yes or no
| String
| Precision 1
|
ByteInt
| Precision 3, scale 0
| Small Integer
| Precision 5, scale 0
|
Char
| Single character
| String
| From 1 through 104,857,600 characters
|
Date
| ANSI SQL date
| Date/Time
| Jan. 1, 0001 A.D. to Dec. 31, 9999 A.D.
(precision to the nanosecond)
|
Float8
| Precision 15
| Double
| Precision 15
|
Float4
| Precision 6, scale 0
| Double
| Precision 15
|
Integer
| Precision 10, scale 0
| Integer
| Precision 10, scale 0
|
NChar(m)
| Single character
Used for storing UTF-8 data
| nString
| From 1 through 104,857,600 characters
|
NVarchar(m)
| BVarchar (length)
Non-blank-padded string, variable storage length
Used for storing UTF-8 data
| nString
| From 1 through 104,857,600 characters
|
Numeric
| Numeric (precision, decimal), arbitrary precision number
Precision must be between 1 and 38
| Decimal
| Precision from 1 through 28 digits, scale from 0 through 28
|
Real
| Precision 6, scale 0
| Real
| Precision of 7, scale of 0
Double-precision floating-point numeric value
|
SmallInt
| Precision 5, scale 0
| Small Integer
| Precision 5, scale 0
|
Time
| hh:mm:ss. ANSI SQL time
| Date/Time
| Jan. 1, 0001 A.D. to Dec. 31, 9999 A.D.
(precision to the microsecond)
|
Timestamp
| Precision 26, scale 6
| Date/Time
| Jan. 1, 0001 A.D. to Dec. 31, 9999 A.D.
(precision to the microsecond)
|
Varchar
| Varchar (length)
Non-blank-padded string, variable storage length
| String
| From 1 through 104,857,600 characters
|
