Re: rowid in temp table
If you need a substitute for ROWID for temp tables, checkout the rownum() function I posted to my blog yesterday. That should serve either while inserting the rows to the temp table or during the fetch back out. If you need a guaranteed stable numbering, then I'd suggest using it when inserting the rows. 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 2:08 PM, Art Kagel <art.kagel@gmail.com> wrote: > Or maybe the DBSPACETEMP environment var for this app changed. Otherwise, > I dunno. > > > 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 2:01 PM, <tomcaml@gmail.com> wrote: > >> we have had multiple items listed in DBSPACETEMP in the ONCONFIG for >> quite some time. It was the only thing I could think of that would have >> done this change. >> >> >> >> >> On Tuesday, September 25, 2012 10:29:13 AM UTC-5, Art S. Kagel wrote: >> > 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, <tom...@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 >> > >> > Inform...@iiug.org >> > >> > http://www.iiug.org/mailman/listinfo/informix-list >> >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> > >
Thanks much, Art