15.10 - LinkID - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Get and set the link ID of a specified point in a GeoSequence.

 

Argument …

Specifies …

index

the index of the point in the GeoSequence, where the index of the first point is 1.

The data type of index is INTEGER.

linkID

the new link ID of specified point in the GeoSequence.

The data type of linkID is DECIMAL(18,0).

 

IF you pass in …

THEN LinkID returns …

index

a DECIMAL(18,0) value for the link ID of the specified point.

index and linkID

an ST_Geometry value that represents a GeoSequence where the link ID for the specified point is set to linkID.

GeoSequence

CREATE TABLE sample_shapes(skey INTEGER, shape ST_Geometry);
 
INSERT INTO sample_shapes ( 100,'GeoSequence( (10 10, 15 15, -2 0) ,(2007-03-14 01:35:00, 2007-03-14 01:35:05, 2007-03-14 01:35:08),(1222, 1223, 1224),(2, 12.1, 3.14159, 2.78128, -10, -11, 100.1))' );
 
   SELECT skey
   FROM sample_shapes
   WHERE ((shape.LinkID(1)) < 9000.0)
   ORDER BY skey;