Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Simmons, Keith — — source: Usenet: comp.databases.informix
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.