Archives of the TeradataForum

Message Posted: Tue, 24 Aug 2004 @ 15:07:34 GMT

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

Hi Karthik,

A solution would be to build dynamically your SQL everyday by using a shell script and the tables: dbc.tables & dbc.columns.

An example to get the tablename: select MAX(tableName) from dbc.tables where tableName LIKE 'myTableName%'

You could also base the query on the createTimeStamp.

The down side is that if you are using a macro (as I think to understand), your user will have to have create & drop macro privs.

Arnaud

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