Re: How do I execute String in Stored Proceedure

Dave Glenn wrote in message ... >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. > >Thanks for any help, > >Dave > You can't use variables in the place of table or column name in SPL. Nor can you use variables to subscript a string. Try ESQL/C and prepare the SQL. It would be easier to answer your question if I knew the version of Informix and any other Informix tools you use.