Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Sep 2003 @ 13:39:02 GMT


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


Subj:   Re: Stored Procedure parms
 
From:   Narayan Murthy K S

No, you cannot use it in the FROM clause, neither is it possible to have it in the COLUMN name list. The only place where you could use the variable in a SELECT statement is as part of the WHERE clause to compare values that to that which is passed.

You could instead do something like constructing the query string, store to some table. Then outside the stored procedure export the string to a file from the table and then fire the query(.run file=....)

Narayan.



     
  <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: 15 Jun 2023