create temporary table in informix

create temp table incomplete(id serial," +
"mobile_no varchar(50)," +
"totalNumber integer," +
"repeated integer," +
"achieved varchar(50))WITH NO LOG

when you execute the sql it will make the temporary table "incomplete" in database server temp space with no logs.

when you close the connection this type of table will be dropped. Sometime, you may have to drop it manully too.