SQL3529N The "EXPORT" operation encountered the unsupported data type

Hi bibi,

What are you trying to export, from what to what and from what platform to what DB etc?

Regards,
murph

b2 export to res.ixf of ixf messages msgs.txt "select * from db2geo.res"
SQL3529N  The "EXPORT" operation encountered the unsupported data type

db2 export to res.ixf of ixf messages msgs.txt "select * from db2geo.res"
SQL3529N  The "EXPORT" operation encountered the unsupported data type

can you post here the ddl to create the table?
one of the data types can't be used by the export command
you either have to find a way to convert it to one of the supported data types, or try to use some other technique to unload the table

do you want to export it for backup purposes? copy to another system?
what is your goal?

Hi bibi,

Normally the message shows you what datatype and what column, like
SQL3529N The EXPORT operation encountered the unsupported data type “data-type” in column “column-number”.

Don't you have this info?

The problem is   in "RES_GEOM" "DB2GSE  "."ST_GEOMETRY" )

CREATE TABLE "DB2  "."RES"  (
                  "RES_ID" INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY (
                    START WITH +1000
                    INCREMENT BY +1
                    MINVALUE +1
                    MAXVALUE +2147483647
                    NO CYCLE
                    NO CACHE
                    NO ORDER ) ,
                  "CODECLIENT" INTEGER NOT NULL ,
                  "CODE_SA" INTEGER NOT NULL ,
                  "RES_PAYS" VARCHAR(4) NOT NULL ,
                  "CODE_DEP" VARCHAR(10) NOT NULL ,
                  "RES_RAISON_SOC" VARCHAR(140) ,
                  "RES_ADR1" VARCHAR(140) ,
                  "RES_ADR2" VARCHAR(140) ,
                  "RES_CODE_POSTAL" VARCHAR(10) ,
                  "RES_VILLE" VARCHAR(140) NOT NULL ,
                  "RES_OFFICIEL" VARCHAR(40) ,
                  "RES_TYPE1" INTEGER NOT NULL ,
                  "RES_TYPE2" INTEGER NOT NULL ,
                  "RES_TYPE3" INTEGER NOT NULL ,
                  "RES_TYPE4" INTEGER NOT NULL ,
                  "RES_X" DOUBLE NOT NULL ,
                  "RES_Y" DOUBLE NOT NULL ,
                  "RES_SCORE" INTEGER NOT NULL ,
                  "RES_VALID" SMALLINT NOT NULL WITH DEFAULT 0 ,
                  "USER_LOCK" VARCHAR(80) ,
                  "CODE_SA_DEP" INTEGER ,
                  "RES_GEOM" "DB2GSE  "."ST_GEOMETRY" )
                 IN "TS_DATA" INDEX IN "TS_INDEX" ;

Thanks

bibi

What do you try to define with "RES_GEOM" "DB2GSE  "."ST_GEOMETRY"  ?
what is the field type?

CREATE TYPE "DB2GSE  "."ST_GEOMETRY"  AS
                ("SRID" INTEGER,
                 "NUMPOINTS" INTEGER,
                 "GEOMETRY_TYPE" SMALLINT,
                 "XMIN" DOUBLE,
                 "YMIN" DOUBLE,
                 "XMAX" DOUBLE,
                 "YMAX" DOUBLE,
                 "ZMIN" DOUBLE,
                 "ZMAX" DOUBLE,
                 "MMIN" DOUBLE,
                 "MMAX" DOUBLE,
                 "AREA" DOUBLE,
                 "LENGTH" DOUBLE,
                 "ANNO_TEXT" VARCHAR(256),
                 "POINTS" BLOB(4190000) LOGGED NOT COMPACT,
                 "EXT" "DB2GSE  "."SE_EXTENSION")
         NOT INSTANTIABLE
         INLINE LENGTH 659
         WITHOUT COMPARISONS
         NOT FINAL
         REF USING VARCHAR(16) FOR BIT DATA
         MODE DB2SQL
         WITH FUNCTION ACCESS;

Select allOpen in new window

Thanks bibi

you won't be able to use export on that data type
what are you trying to do?

I want to copy this table to another db.

only this table?

All the tables of a schema. Thanks

Thanks bibi