Archives of the TeradataForum

Message Posted: Fri, 01 Jul 2005 @ 16:08:00 GMT

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

<-- Anonymously Posted: Friday, July 01, 2005 11:43 -->

Hi,

Since the table name is decided dynamically, you can create a table to hold the SQLs which are formed on the fly like :

     Sequence_no  SQL_text
     --------------------
     1           'SELECT count(*) FROM table_a;'
     2           'SELECT count(*) FROM table_b;'
     3           'SELECT count(*) FROM table_c;'

with the table names -table_a, table_b, table_c being passed at run time.

Then you can Export the SQLs to a file which can later be executed in BTEQ using the .Run command.

Hope this works for you.

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