User's Guide and Reference

ST_Point

ST_Point returns an ST_Point, given an x-coordinate, y-coordinate, and spatial reference.

Syntax

db2gse.ST_Point(X Double, Y Double, srs SRID)

Return type

db2gse.ST_Point

Examples

The following CREATE TABLE statement creates the POINT_TEST table, which has a single point column, PT1.

CREATE TABLE POINT_TEST (pt1 db2gse.ST_Point)

The ST_Point function converts the point coordinates into a point geometry before the INSERT statement inserts it into the PT1 column.

INSERT INTO point_test VALUES(
    db2gse.ST_Point(10.01,20.03, db2gse.coordref()..srid(0))
)


[ Top of Page | Previous Page | Next Page ]