Designer Guide

10.5.6
- 10.5.7
- 10.5
- 10.4.1
- 10.4.0

Back Next

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

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

IBM DB2 and Transformation Datatypes

IBM DB2 and Transformation Datatypes