Create Stored Procedure

Friends, Sorry for this lengthy question. Is there a way of creating a temporary procedure (like temp table) in INFORMIX IDS. I just want to create this procedure(which will have an if condition, few variable defines and a foreach loop). Once done, I will drop the procedure within the same dbaccess session. From a UNIX script, I run dbaccess and get all the "char" fields and their length into a file. To do that, 1. I create a temp table. 2. Get all the char fields and their length from all the tables in the database into this temp table. 3. Create a procedure to check if any of the fields in the temp table have the same name and length and get rid of the duplicates. 4. unload the temp table into a flat file. 5. The script then appends a few more stuff to the flat file generated. I get a -329 informix error as I do not have permission(for security compliance) to create procedure or tables. I was able to create temp tables. Is there any way of creating a temp procedure to do the logic in step 3. I need to do all this in a single dbaccess session, if not i will loose the temp table. Please help. Thanks Nag