Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016