C:\Program Files\Teradata\Client\17.20\bin>java com.teradata.geo.TDGeoImport -l hyvm111/ab2,ab2 -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected ============================================== = Teradata GeoImport VERSION 17.20.00.00 = = = = Copyright 2014-2022 Teradata. = = ALL RIGHTS RESERVED. = ============================================== DatabaseName = geouser Data Source = C:\GeoSpatial\TestEnv\geodata LayerName = customers LOGMECH = TD2 Logon = hyvm111/ab2,**** Data Source = D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected connecting to hyvm111 ... connected! Validating layer: SOIL_IA_REJECTED_SEQ All layers successfully validated. ------------------------------------------- Importing layer SOIL_IA_REJECTED_SEQ to table SOIL_IA_REJECTED_SEQ... (427/427) =========================================== Data importing finished successfully! Importing time is 61.266 Bteq out shows as follows: BTEQ -- Enter your SQL request or BTEQ command: show table ab2.SOIL_IA_REJECTED_SEQ; show table ab2.SOIL_IA_REJECTED_SEQ; *** Text of DDL statement returned. *** Total elapsed time was 1 second. --------------------------------------------------------------------------- CREATE SET TABLE ab2.SOIL_IA_REJECTED_SEQ ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( AREASYMBOL VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, SPATIALVER FLOAT, MUSYM VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC, MUKEY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC, GEOM SYSUDTLIB.ST_Geometry) PRIMARY INDEX ( AREASYMBOL ); BTEQ -- Enter your SQL request or BTEQ command: sel count(*) from ab2.SOIL_IA_REJECTED_SEQ; sel count(*) from ab2.SOIL_IA_REJECTED_SEQ; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. Count(*) ----------- 91 Case 2: Database used is ab and -m option data files are from D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected. C:\Program Files\Teradata\Client\17.20\bin>java -l hyvm111/ab2,ab -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected -m ============================================== = Teradata GeoImport VERSION 17.20.00.00 = = = = Copyright 2014-2022 Teradata. = = ALL RIGHTS RESERVED. = ============================================== DatabaseName = geouser Data Source = C:\GeoSpatial\TestEnv\geodata LayerName = customers LOGMECH = TD2 Logon = hyvm111/ab2,**** connecting to hyvm111 ... connected! Validating layer: SOIL_IA_REJECTED_SEQ All layers successfully validated. ------------------------------------------- Importing layer SOIL_IA_REJECTED_SEQ to table SOIL_IA_REJECTED_SEQ... (427/427) =========================================== Data importing finished successfully! Importing time is 105.641 Bteq out shows as follows: BTEQ -- Enter your SQL request or BTEQ command: show table ab.SOIL_IA_REJECTED_SEQ; show table ab.SOIL_IA_REJECTED_SEQ; *** Text of DDL statement returned. *** Total elapsed time was 1 second. --------------------------------------------------------------------------- CREATE MULTISET TABLE ab.SOIL_IA_REJECTED_SEQ ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( AREASYMBOL VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC, SPATIALVER FLOAT, MUSYM VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC, MUKEY VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC, GEOM SYSUDTLIB.ST_Geometry) PRIMARY INDEX ( AREASYMBOL ); BTEQ -- Enter your SQL request or BTEQ command: sel count(*) from ab.SOIL_IA_REJECTED_SEQ; sel count(*) from ab.SOIL_IA_REJECTED_SEQ; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. Count(*) ----------- 427