Unanswered: Insert results of execute procedure into a table
I am trying to insert the results of an informix stored procedure into a table. I tried to do
insert into temp_test Execute procedure test()
I get an error- Illegal SQL statement in SPL routine.
I am plugging into a client system where I dont have access to modify any procedures that are built already. I just need the results of what comes back from the procedure to be stored in a temp table so I can run some roll ups on it. Is this possible to do in informix?