Archives of the TeradataForum
Message Posted: Tue, 13 Jan 2004 @ 14:36:47 GMT
<-- Anonymously Posted: Tuesday, January 13, 2004 09:30 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|