Question & Answer
Question
How can I export to a shapefile if my table contains BLOB data?
Answer
The current shape export function fails when the table contains data types that are not supported in a shapefile, such as BLOB, FOR BIT DATA, or BIGINT.
To work around this limitation,
- Use the CREATE VIEW statement to define a view based on the original table. In this definition, only include columns with data types that are supported by shapefiles:
- Smallint, Integer
- Decimal
- Real, Double
- Char, Varchar (string length less than 255)
- Date
- Register the spatial column in the view as layer.
- Run the shape export function using the new view.
- The VIEW must also include one (and only one) spatial column.
If you do not have the necessary privileges to create a view, contact your database administrator.
[{"Product":{"code":"SSYUVL","label":"Db2 Spatial Extender for Linux, UNIX and Windows"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Import\/Export","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.1;9.5;9.7;10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21054445