HOW TO
Instructions provided describe the steps to convert a DB2 spatial table into a feature class to be used by ArcGIS.
Code:
db2 => CREATE TABLE "MAP"."POLY"
("POLY_ID" BIGINT , "POLY_TYPE" INTEGER , "REASON_COD" INTEGER , "SOURCE_" INTEGER ,
"SOURCE_SUB" INTEGER , "QUAL" INTEGER , "ASSR_POLY_" BIGINT , "RCD_POLY_I" BIGINT ,
"TRNX_UID" VARCHAR(5) , "TRNX_DATE" DATE , "TRNX_PROG" VARCHAR(8) , "STOP_DATE" DATE ,
"SHAPE" "DB2GSE "."ST_MULTIPOLYGON" , "OBJECTID" INTEGER NOT NULL WITH DEFAULT 0 )
IN "SDEDB2" INDEX IN "SDEINDEX" LONG IN "SDELOBS"
Code:
c:\>sdelayer -o register -l map.poly,shape -e a+
-C objectid,SDE -u map -p map -i 5920
- R <srid used to register the table with the Spatial Extender>
Note:
The -R option must be specified. If it is not, data cannot be loaded into the feature class.
Note:
The table has to be unregistered then registered again before the data can be loaded.
Code:
c:>sdelayer -o delete -l map.poly,shape -u map -p map -i 5920
Article ID:000009910
Get help from ArcGIS experts
Download the Esri Support App