Re: How do I execute String in Stored Proceedure

Dave Glenn wrote: > I need to do an alter table on several similar tables. I can get the > table name and constraint via sql and a cursor. However when I plug > those variables into an alter table statement it see them as the > variable name and not the value. In MS SQL server I used the > execute immediate statement but I see nothing similar in Informix. Primarily because there is nothing similar in Informix SPL. The statements in SPL are strictly static -- preparable when the SP is compiled. You need dynamic SQL, which is not an option in Informix SPL. No, I don't like it; but that is the way it is. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.59 -- see http://www.perl.com/CPAN #include <disclaimer.h>