Archives of the TeradataForum

Message Posted: Tue, 01 Jul 2003 @ 17:01:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

Hopefully someone will be able to help me with this.

I am working on a geographical database and was asked to write a stored procedure to determine if there are any data points with a specified range of a given lat, lon coordinate pair. My stored procedure returns a true/false answer and works correctly. No I come to find out that my boss wants to call my procedure from a query statement. I don't think can be done or at least haven't figured out how to do it yet. Can some help me.

Here is what he wants to do: (infotable is a customer supplied table that we check against our datatable)

select * from infotable where myprocedure(infotable.lat, infotable.lon, 10, ans) = true;

This throws an error, but can something like thins be done.

Stacy Johnson
Programmer/Analyst
Planning Systems Inc.

	<Prev	Next>		<<First	<Prev	Next>	Last>>