ArcGIS Server Banner

DB2 data types

DB2 data types
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to DB2 types in the following table:


ArcGIS data type DB2 data type Notes
OBJECTID INTEGER(4) NOT NULL
SHORT INTEGER SMALLINT(2)

LONG INTEGER INTEGER(4)

FLOAT DECIMAL(31,8)

DOUBLE DECIMAL(31,8)

TEXT VARCHAR(n)

DATE TIMESTAMP

BLOB BLOB

GUID CHARACTER(38)

GEOMETRY ST_GEOMETRY ST_Geometry is a superclass. The actual data subtype created (such as ST_Multilinestring or ST_Point) depends on what type of feature class you create, whether as polygon, line, point, multipoint, or multipatch.
RASTER BLOB

See Also

  • About data types
  • About geometry storage types