As I mentioned in a previous message, We are currently
working on introducing spatial functions to SQS. These are
functions that would operate on spatial data, to allow some
additional analysis of a column in your database.

The first one we implemented was SQSArea(). We are now
introducing SQSLength (perimeter/circumference)
Here's a sample of how it might be used:

create table lengthtest(v varchar(200), shape ellipse)
insert into areatest values ("ellipse equal radius 1 deg at
equator", ellipse(0N, 0E, 30 nm, 30 nm, 82))
insert into areatest values ("elilipse equal radius1 deg at
179.5", circle(0N, 179.5, 30 nm, 30 nm, 62))
insert into areatest values ("ellipse radius 1 deg at pole",
circle(90N, 0W, 30 nm, 30 nm, 172))
insert into areatest values ("ellipse 20x40 at pole",
circle(90N, 0W, 20 nm, 40 nm, 129))
select v, SQSLength(shape, "nautical miles") from lengthtest
where SQSLength(shape, "meters") > 100

The SQSLength function take a spatial column as its first
argument, and units as its second argument (meters, nautical
miles, kilometers, etc -- see the manual for a full list)

Of course, SQSLength() can be used on most spatial data
including circle, line, line_set, ellipse, llbox,llbox_set,
polygon, polygon_set, rectangle, and rectangle_set.

The new spatial function capability will be released in mid
2008, in SQS 3.8. It will also be possible to use it in CIS
as well, as long as you are running 15.0.2 ESD#2 or later.

If you wish, let me know of any other spatial functions you
might be interested in having us implement.

Geoffrey Greene
SQS Technical Lead