I am pretty new to informix, please excuse any dumb question
Our admin is not at hand and I want to try some statements that use temp tables, what I have never tried before. Before I run these statements I would like to know what the DB does with the temporary tables after the statements are executed. Are the tables deletet automatically or do I have to drop them at the end of my session?
What happens if there is not enough space for the temp table? Can I do any harm to our server with my temp table tests?
Temporary tables are deleted automaticaly after user session is disconnected or you can use "drop table temptablename" after temp table creation
Informix Administrator can define temporary dbspace for temporary tables or if these temporary dbspaces does not exists, engine places them in root dbspace, but it is not good solution, because rootdbspace is critical dbaspace.