Archives of the TeradataForum
Message Posted: Tue, 01 Jul 2003 @ 17:01:08 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|