Error while exporting data into ESRI shapefile using TDGeoExport

Extensibility

Error while exporting data into ESRI shapefile using TDGeoExport

Hi,

I am trying to Export data from a table to shapefile(i.e  .shp file) using TDGEOIMPORTEXPORT which runs through java,  When I am running this ( C:\TdGeoImportExport\bin>java -Xms256m -Xmx512m  -classpath .;"c:\Program Files\

Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\b

in\tdgssjava.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";.

com.teradata.geo.TDGeoExport -l 127.0.0.1/dbc,dbc -s tpch -t shapes_sam  -f "ESR

I Shapefile" multipolygon -o C:\GEOSPATIAL_FOLDER -n shapes_sam)
  from my CMD prompt,  I am running into below issue, can some one suggest how to over come this issue. FYI..here is the table structure from which I am trying to import data from:

CREATE SET TABLE tpch.TERR_GEO ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT

     (

      TERRITORY_CODE VARCHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC,

      ZIP VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,

      GEOM SYSUDTLIB.ST_Geometry)

PRIMARY INDEX ( ZIP );

C:\TdGeoImportExport\bin>java -Xms256m -Xmx512m  -classpath .;"c:\Program Files\

Teradata\Tdat\LTDBMS\bin\terajdbc4.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\b

in\tdgssjava.jar";"c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";.

com.teradata.geo.TDGeoExport -l 127.0.0.1/dbc,dbc -s tpch -t shapes_sam  -f "ESR

I Shapefile" multipolygon -o C:\GEOSPATIAL_FOLDER -n shapes_sam

Coordinate System defaulting to NAD83.

WARNING: There is data in the directory C:\GEOSPATIAL_FOLDER which was specified

.

If you continue, and there is pre-existing data for layer SHAPES_SAM,

all data for that layer will be OVERWRITTEN.

Would you like to continue? [y,n] y

Logon        = 127.0.0.1/dbc,dbc

DatabaseName = TPCH

Table Name   = SHAPES_SAM

Export to    = C:\GEOSPATIAL_FOLDER\SHAPES_SAM

File Format  = ESRI Shapefile

Shape Type   = MULTIPOLYGON

Only 1 Type  = FALSE

-------------------------------------------

connecting to 127.0.0.1 ... connected!

-------------------------------------------

exporting table SHAPES_SAM to layer SHAPES_SAM ...

java.sql.SQLException: TPCH.SHAPES_SAM has below un-supported data types:

 Column geometry is OTHER

        at com.teradata.geo.TabDef.getOFTTypes(TabDef.java:201)

        at com.teradata.geo.TabDef.<init>(TabDef.java:86)

        at com.teradata.geo.TDGeoExport.Processtable(TDGeoExport.java:468)

        at com.teradata.geo.TDGeoExport.main(TDGeoExport.java:718)

Exporting data failed.

===========================================

Data exporting failed!

Thank you and Appreciate your help .......Shyam