Is it possible to do some dynamic SQL in a stored procedure ?

[Like the EXECUTE IMMEDIATE in Oracle]

I want to create a string withan SQL statement and execute it :
ie

define Strsql varchar(100);

LET Strsql = "insert int " || table_name || "values (" || val || ");";
where table_name and val are parameters

and then execute this statement (= execute the insert)

Sorry this is not possible in IDS with normal SPL commands. I beleive there is bladelet that can be used to achieve this in IDS 9. You coulld check the IBM website for this. I think I've seen it in developerswork corener of Informix in the datablade section. But it is not as easy as with Oracle.

Hope this helps,


Rob