D:\RAJU\GeoSpatial\bin>java -classpath .;terajdbc4.jar; tdgssconfig.jar; com.teradata.geo.TDGeoImport -l hyvm111/ab2,ab2 -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected Logon = hyvm111/ab2,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. D:\RAJU\GeoSpatial\bin>java -classpath .;terajdbc4.jar; tdgssconfig.jar; com.teradata.geo.TDGeoImport -l hyvm111/ab,ab -f D:\RAJU\GeoSpatial\ESRI\RECEH5ZRS_rejected -m Logon = hyvm111/ab,ab 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 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