DB2 Spatial Quick Facts

About Quick Facts Tables

Format Type Identifier

DB2SPATIAL

Reader/Writer

Both

Licensing Level

Reading: Professional and above

Writing: Database Edition

Dependencies

ODBC driver

Dataset Type

Data source name

Feature Type

ODBC Data Source Name (DSN)

Typical File Extensions

Not applicable

Automated Translation Support

Yes

User-Defined Attributes

Yes

Coordinate System Support

Yes

Generic Color Support

No

Spatial Index

Yes, except on z/OS

Schema Required

Yes

Transaction Support

Yes

Geometry Type

db2_type

DB2 Spatial Geometry Support

Geometry

Supported?

aggregate

yes

circles

no

circular arc

no

donut polygon

yes

elliptical arc

no

ellipses

no

line

yes

none

yes

point

yes

polygon

yes

raster

no

solid

no

surface

no

text

no

z values

no