Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    15

    Unanswered: basic temp table questions

    hello,
    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?

    best regards,
    sven

  2. #2
    Join Date
    Aug 2006
    Location
    Riga, Latvia
    Posts
    17
    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.

  3. #3
    Join Date
    Aug 2006
    Posts
    15
    Thank you for the fast reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •