Archives of the TeradataForum

Message Posted: Fri, 12 Sep 2003 @ 13:39:02 GMT

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

No, you cannot use it in the FROM clause, neither is it possible to have it in the COLUMN name list. The only place where you could use the variable in a SELECT statement is as part of the WHERE clause to compare values that to that which is passed.

You could instead do something like constructing the query string, store to some table. Then outside the stored procedure export the string to a file from the table and then fire the query(.run file=....)

Narayan.

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