Archives of the TeradataForum
Message Posted: Mon, 28 Jan 2002 @ 20:25:06 GMT
No you can't do it. To create the query dynamically, there is a constraint in teradata. You, cannot use Select statement.
You can do something like this,
CREATE PROCEDURE sample_table(my_table VARCHAR(30),
The following SQL statements cannot be used as dynamic SQL in stored procedures:
Hope this helps you.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|