LineFromShape takes a shape of type point and a spatial reference system identity and returns a linestring.
Syntax
db2gse.Line FromShape(ShapeLineString Blob(1M), cr db2gse.coordref)
Return type
db2gse.ST_LineString
Examples
The following code fragment populates the SEWERLINES table with the unique id, size class, and geometry of each sewer line.
The CREATE TABLE statement creates the SEWERLINES table, which has three columns. The first column, SEWER_ID, uniquely identifies each sewer line. The second column, CLASS, of type integer identifies the type of sewer line, which is generally associated with a line's capacity. The third column, SEWER, of type linestring stores the sewer line's geometry.
CREATE TABLE SEWERLINES (sewer_id integer, class integer,
sewer db2gse.ST_LineString);
/* Create the SQL insert statement to populate the sewer_id, size class and
the sewer linestring. The question marks are parameter markers that
indicate the sewer_id, class and sewer geometry values that will be
retrieved at runtime. */
strcpy (shp_sql,"insert into sewerlines (sewer_id,class,sewer)
values (?,?, db2gse.Line FromShape (cast(? as blob(1m)),
db2gse.coordref()..srid(0)))");
/* Allocate memory for the SQL statement handle and associate the
statement handle with the connection handle. */
rc = SQLAllocStmt (handle, &hstmt);
/* Prepare the SQL statement for execution. */
rc = SQLPrepare (hstmt, (unsigned char *)shp_sql, SQL_NTS);
/* Bind the integer key value to the first parameter. */
pcbvalue1 = 0;
rc = SQLBindParameter (hstmt, 1, SQL_PARAM_INPUT, SQL_C_SLONG,
SQL_INTEGER, 0, 0, &sewer_id, 0, &pcbvalue1);
/* Bind the integer class value to the second parameter. */
pcbvalue2 = 0;
rc = SQLBindParameter (hstmt, 2, SQL_PARAM_INPUT, SQL_C_SLONG,
SQL_INTEGER, 0, 0, &sewer_class, 0, &pcbvalue2);;
/* Bind the shape to the third parameter. */
pcbvalue3 = blob_len;
rc = SQLBindParameter (hstmt, 3, SQL_PARAM_INPUT, SQL_C_BINARY,
SQL_BLOB, blob_len, 0, sewer_shape, blob_len, &pcbvalue3);
/* Execute the insert statement. */
rc = SQLExecute (hstmt);