Archives of the TeradataForum
Message Posted: Fri, 25 Oct 2002 @ 22:34:48 GMT
<-- Anonymously Posted: Friday, October 25, 2002 17:38 -->
As a part of a bigger Stored Procedure there are a couple of tables I'd like to run an Insert statement against. This Insert is 99% the same for each table, the differences being the Table Name and some condition in the Where clause.
So, I'm thinking that I can use the Procedure to run this Insert one time for each table, while using variables to swap in the differences. The Where clause swap I've got, but I'm running into trouble changing the Table Name for the Insert.
Here's a quick example, using tables TableOne, and TableTwo :
CREATE PROCEDURE TestStProc (IN tblName CHAR(8), IN criteria CHAR(1) ) BEGIN INSERT INTO :tblName SELECT * FROM some_table WHERE Code = :criteria; END;
I know it's wrong, because I get a compile time syntax error at the 'INTO:'. So, is there any way to use variables as Table Names? Should I use a different approach?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|