Slide 12
Slide 12 text
%Cͷཧۭؒੳػೳ
ۭؒσʔλλΠϓͷม
© 2022 IBM Corporation
12
42-Ͱͷมྫ
Ңɾܦͷ͕͋Δ߹ɺۭؒॲཧؔ45@1PJOUؔΛͬͯม
INSERT INTO SAMPLE_POINTS1(id, geom)
VALUES(100, ST_Point(135, 35));
γΣΠϓɾϑΝΠϧ͔ΒͷۭؒσʔλͷΠϯϙʔτྫ
γΣΠϓϑΝΠϧ͕͋Δ߹ɺECTFJNQPSU@TIBQFίϚϯυΛͬͯม
db2se import_shape DOJOWOC -userId bluadmin -pw xxxx -sa 1
-fileName /N03-20210101_13_GML/tokyo.shp -createTableFlag 1
-srsName GCS_JGD_2011 -tableSchema DOJOUSER_99
-tableName CITY_SHAPE -spatialColumn geo -idColumn OBJECTID
-idColumnIsIdentity 1 -commitScope 200 -client 1
ˢ࣮ࡍʹࠓճͷϋϯζΦϯ༻ʹࠃަ௨লͷ౦ژͷߦ۠ҬσʔλΛΠϯϙʔτͨ͠ίϚϯυͰ͢ ͨͩ͠จࣈίʔυͷ
65'มΛผ్ͨ͠ޙʹ࣮ߦ͍ͯ͠·͢