Re: Temp Tables location

> In the INFORMIX Guide to SQL Tutorial manual p. 10-6 it suggest setting > up a single dbspace for temporary tables in OnLine. I realize that for > explicit temp tables (ie create temp table) that I can specify the dbspace. > But how can I specify the dbspace for implicit temp tables (such as 4gl > cursors, select into temp) or sort temp tables on a single processor system > (order by's). In the Standard Engine I can do this by setting the environmental > variable DBTEMP. However, my understanding is that this doesn't work with > OnLine. > Maria I think what the manual should say is that in Online you should define rootdbs to be the size required for your temporary tables and place all your actual tables and databases in other dbspaces. You are right in saying that there is no method of predefining the temporary table area for online it always defaults to rootdbs. Cheers - Jim -------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 358-5911 (Work) Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home) San Mateo, CA 94402 Fax: (415) 571-6429 --------------------------------------------------------------------