Substituting a table name in a stored procedure query

Posted in 1995

Mark Denham — 2 Aug 1995 04:58:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Nope, Not in V5 at least. You must write the queries separately in the stored procedure, processing each in turn in a FOREACH loop. mark Denham BBC London UK Mark.Denham@bbc.co.uk >I would like to build a stored procedure that will execute the same >query for several different tables. Is their a way to do a PREPARE in >a stored procedure? Is their some other way of doing this? >Thanks for any help. >Alan J. Rothstein >(212) 525-8000 >alan@dpg.rnb.com