Dynamic Table names in Stored Procedures?

[Terafic]

Can the table name be passed into a stored procedure as a parameter?
I have mutiple identical tables and am trying to read them using one stored procedure with the table name passed into the procedures as a parameter.

thanks

 

[tdatgod]

Hi,
this feature is in 4.1. There are some limitations on the use of DYNAMIC SQL in stored procedure.

You can look at the SQL reference manual volume 6 on stored procedure language

http://www.info.ncr.com/sd/sd-1.cfm?page=td

click on

SQL reference

and find volume 6 for Release 4.1.x