Informix stored procedure's question

Cum de scris o procedura p-u sgbd informix care ar executa un string sqlceva de tipu CREATE PROCEDURE myproc()returning int;DEFINE var_int ;DEFINE sql_str = 'select count(*) form table_name';let var_int = exec(sql_str); // aicea nu merge ashareturn var_int;end procedure;nicaieri nu gasesc.. in MSSQl mai simplu am intsales.. da nii intre informixthanx anticipat