RE: explicit TEMP table in rootdbs?

Darren As follows :- create TEMP table <tabname> ( column list .... ) WITH NO LOG; will create the temp table in your temp dbspaces. There are several previous threads on the whys and wherefores of this if you need further information. Keith -> -----Original Message----- -> From: Darren_Jacobs@carmax.com [mailto:Darren_Jacobs@carmax.com] -> Sent: Tuesday, March 15, 2005 2:08 PM -> To: ids@iiug.org; informix-list@iiug.org -> Subject: explicit TEMP table in rootdbs? -> -> -> All, -> -> I'm having a problem with an explicit TEMP table being created in my -> rootdbs. I have 6 temp dbspaces created at 1 gig each. My entry for -> dbspace temp in my onconfig file is below. -> -> create TEMP table <tabname> -> ( -> column list .... -> ); -> -> Any help would be greatly appreciated. -> -> $ onstat -c|grep TEMP -> # DBSPACETEMP: -> # Dynamic Server equivalent of DBTEMP for SE. This is the -> list of dbspaces -> DBSPACETEMP temp1:temp2:temp3:temp4:temp5:temp6 # -> Default temp dbspaces -> -> sending to informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list