CREATE TABLE lakes ( fid INTEGER NOT NULL, name VARCHAR(64), shore ST_Geometry ) UNIQUE PRIMARY INDEX (fid); CALL SYSSPATIAL.AddGeometryColumn('','OpenGISU','lakes','shore',988, 'ST_Polygon', 0.0, 1.0, 1000.0, 1001.0, s );
Output:
resultString ----------------------------------------------------- shore in table OpenGISU.lakes was successfully added.
CREATE TABLE road_segments ( fid INTEGER NOT NULL, name VARCHAR(64), centerline ST_Geometry ) UNIQUE PRIMARY INDEX (fid); CALL SYSSPATIAL.AddGeometryColumn( '', 'OpenGISU', 'road_segments', 'centerline', 988, 'ST_LineString', 0E0, 1E0, 1E3, 1.001E3, s );
Output:
resultString ------------------------------------------------------------------ centerline in table OpenGISU.road_segments was successfully added.