Archives of the TeradataForum

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

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

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>>