The following steps and examples describe how to import with the Teradata GeoImport utility.
- Drop the customers table from the database:
DROP TABLE customers;
- Run TDGeoImport to import the ESRI shape files into the DBS:
cd c:\temp\TdGeoImportExport\bin java -Xms256m -Xmx512m -classpath .;"c:\Program Files\Teradata\Tdat\LTDBMS\bin\terajdbc4.jar"; "c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssjava.jar"; "c:\Program Files\Teradata\Tdat\LTDBMS\bin\tdgssconfig.jar";. com.teradata.geo.TDGeoImport -l hyvm20/ geouser, geouser -s geouser -f c:\temp\geodata -n customers
- Validate that shape files were loaded into customers table:
SEL pkey, point (FORMAT 'X(20)'), cust_name (FORMAT 'X(20)'), cust_zipco FROM customers ORDER BY 1;