Archives of the TeradataForum

Message Posted: Tue, 13 Jan 2004 @ 14:36:47 GMT

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

<-- Anonymously Posted: Tuesday, January 13, 2004 09:30 -->

Greetings,

I have a need to run a stored procedure containing a dynamic sql by passing arguments obtained from the environment variables, what is the best way ro run this SP? Any suggestions appreciated. What the SP does is, gets the database name, tablename and a column name as 3 arguments and run a SQL to find out the # of rows, min, max of that column passed and inserts the result into an audit table. Only way that occurs to me is to write a bteq script on the fly and then execute that.

Thanks

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