Re: explicit TEMP table in rootdbs?
Separators can be either colon or comma.
"Jay Aymond"
<jaymond@communit
ycoffee.com> To
Sent by: informix-list@iiug.org
owner-informix-li cc
st@iiug.org
Subject
Re: explicit TEMP table in rootdbs?
03/15/2005 11:52
AM
Please respond to
"Jay Aymond"
<jaymond@communit
ycoffee.com>
I'm not positive, but I think you need commas between the dbspace names,
not
":".
<Darren_Jacobs@carmax.com> wrote in message
news:1110903083.b833eb8aa70a42e88fb9a4879f7f871a@teranews...
>
> 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
sending to informix-list