SQL3529N The "EXPORT" operation encountered the unsupported data type

Hello,

How can I resolve this problem?

Thanks

bibi
bibi92Asked:
Who is Participating?
 
MurpheyApplication ConsultantCommented:
Hi bibi,

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

Regards,
murph
0
 
bibi92Author Commented:
b2 export to res.ixf of ixf messages msgs.txt "select * from db2geo.res"
SQL3529N  The "EXPORT" operation encountered the unsupported data type
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
bibi92Author Commented:
db2 export to res.ixf of ixf messages msgs.txt "select * from db2geo.res"
SQL3529N  The "EXPORT" operation encountered the unsupported data type
0
 
momi_sabagCommented:
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?
0
 
MurpheyApplication ConsultantCommented:
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?
0
 
bibi92Author Commented:
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
0
 
MurpheyApplication ConsultantCommented:
What do you try to define with "RES_GEOM" "DB2GSE  "."ST_GEOMETRY"  ?
what is the field type?
0
 
bibi92Author Commented:
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;

Open in new window

Thanks bibi
0
 
momi_sabagCommented:
you won't be able to use export on that data type
what are you trying to do?
0
 
bibi92Author Commented:
I want to copy this table to another db.
0
 
momi_sabagCommented:
only this table?
0
 
bibi92Author Commented:
All the tables of a schema. Thanks
0
 
bibi92Author Commented:
Thanks bibi
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.