Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Calling a Stored procedure from a Query
From:   stacy johnson


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
Planning Systems Inc.

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020