Re: temp tables and rowid

export DBSPACETEMP=tempdbs use only one TEMP dbspace, otherwise temp tables will be fragmented, and therefore don't have rowid's. you could also "set pdqpriority to 0" In short: when temp tables are fragmented (this might happen automatically) they don't have rowid's Andreas Zeugswetter mabinm@valuerx.com wrote: > Before I'm told that I shouldn't use rowids, I don't have a lot of choice > right now, given that this application was designed this way and I have been > given the task of pointing it to a different database. Here's the situation: > > My application executed a select into temp table query. It then did a select > on the temp table limiting the results returned by rowid. What worked in the > former database leads to an error 857 "rowids do not exist on table" in the > new database. Are there any parameters that might be set to cause the > creation of temp tables without rowids? Another note of interest, both > databases have tables with rowids on them. > > Hope someone can help. > > Thanks. > > Mike > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading