rowid in temp table

hello, For some reason, we now see a -857 error (Rowids do not exist on table) when running a select rowid against a temp table. We are on version 11.7.FC5 on AIX 6.1 There were no config nor version changes but it worked fine on friday and then started getting the error on monday - any ideas? thanks tom

If you have DBSPACETEMP set to multiple temp dbspaces, either in the ONCONFIG file or overridden by the users' environment, the engine will fragment/partition temp tables across all of them and partitioned tables do not have rowids. Is it possible that the value in DBSPACETEMP was changed? Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Sep 25, 2012 at 10:45 AM, <tomcaml@gmail.com> wrote: > hello, > For some reason, we now see a -857 error (Rowids do not exist on table) > when running a select rowid against a temp table. We are on version > 11.7.FC5 on AIX 6.1 > There were no config nor version changes but it worked fine on friday and > then started getting the error on monday - any ideas? > > thanks > tom > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >