Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

IBM DB2 and Transformation Datatypes

IBM DB2 and Transformation Datatypes

The following table compares IBM DB2 datatypes and transformation datatypes:
Datatype
Range
Transformation
Range
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Blob
1 to 2,147,483,647 bytes
Binary
1 to 104,857,600 bytes
Char(L)
1 to 254 characters
String
1 to 104,857,600 characters
Char for bit data
1 to 254 bytes
Binary
1 to 104,857,600 bytes
Clob
1 to 2,447,483,647 bytes
Text
1 to 104,857,600 characters
Date
0001 to 9999 A.D.
Precision 19; scale 0 (precision to the day)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Dbclob
Up to 1 GB
Ntext
1 to 104,857,600 characters
Decimal(P,S)
Precision 1 to 31, scale 0 to 31
Decimal
Precision 1 to 28, scale 0 to 28
Float
Precision 1 to 15
Double
Precision 15
Graphic
1 to 127 bytes
Nstring
1 to 104,857,600 characters
Integer
-2,147,483,648 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Long Varchar
1 to 32,700 characters
String
1 to 104,857,600 characters
Long Vargraphic
Up to 16,350 bytes
Ntext
1 to 104,857,600 characters
Numeric(P,S)
Precision 1 to 31, scale 0 to 31
Decimal
Precision 1 to 28, scale 0 to 28
Smallint
-32,768 to 32,767
Small Integer
Precision 5, scale 0
Time
24-hour time period
Precision 19, scale 0
(precision to the second)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
26 bytes
Precision 26, scale 6
(precision to the microsecond)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Varchar
Up to 4,000 characters
String
1 to 104,857,600 characters
Varchar for bit data
Up to 4,000 bytes
Binary
1 to 104,857,600 bytes
Vargraphic
Up to 16,336 bytes
String
1 to 104,857,600 characters


Updated July 02, 2020