Need help creating a Stored Procedure for creating tables.

General
Highlighted
Teradata Employee

Need help creating a Stored Procedure for creating tables.

Greetings,

 

I am fairly new with SP development in TD and I need help or at least a point in the right direction on how to create a stored procedure, which will loop through a SQL query say "select requesttext  from DB.TEMPTABLEDDLLIST" and from that list of table DDLs execute and create the tables within that loop. From what I know the way to achieve this is through a cursor and loop through the results, but if there is a better way to do it I am ok also with this approach. Appreciate the help.

 

regards,

 

Karl