Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Jan 2005 @ 09:04:02 GMT


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


Subj:   Dynamic Query
 
From:   Babu_Gopal

Hi Folks,

I need to pass db and table to the query to get some results that I am doing it through procedure.

Please guide how can I proceed. I have written a query and passing two parameters which is getting assiged in the query then the query will be passed to CALL SYSEXECSQL(:PARAM) Which is throwing error. apart from the above method is there any other way we can implement this dynamic query operation.

please let me know asap. your partience and response would be very much apprciated.


Thanks & Warm Regards

Babu G



     
  <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