Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Jan 2005 @ 15:23:41 GMT


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


Subj:   Re: Dynamic Query
 
From:   Muthusamy, Sudha

Babu

Here is another way of running the dynamic query

Write the dynamic SQL to a file and you can run the file

I am sending a sample script to perform the following functions

1. to pass a runtime variable

2. export the dynamic SQL to file

3. run the dynamic SQL file


Let me know if you need more clarification


Thanks

Sudha


     Sample script
     --------------------

     home=$HOME
     tablename=temp
     xstrategy_number=1111

     bteq<

 
 
 
 


     
  <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: 23 Jun 2019