[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

SQL3529N The "EXPORT" operation encountered the unsupported data type

Hello,

How can I resolve this problem?

Thanks

bibi
0
bibi92
Asked:
bibi92
  • 7
  • 4
  • 3
1 Solution
 
theo kouwenhovenCommented:
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
 
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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
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
 
theo kouwenhovenCommented:
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
 
theo kouwenhovenCommented:
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
 
momi_sabagCommented:
0
 
bibi92Author Commented:
Thanks bibi
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 7
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now