Re: PERFORM and fragmentation

Posted in 1995

Jonathan Leffler — 21 Jun 1995 16:58:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Yes. Do not try to use SPERFORM (any version) on Fragmented Tables -- it won't work correctly. I believe this applies whether you have the physical column ROWID present in the table or not. This is a known bug (B32819), but there is no intention to fix it (at the moment, at any rate). To fix it involves a complete rewrite of the data manipulation portion of PERFORM. This is overdue (for other reasons) but unlikely to happen. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: Mark Steele <74431.3327@CompuServe.COM> >Date: 20 Jun 1995 21:50:16 GMT >X-Informix-List-Id: <news.14847> > >I am trying to query a table in 7.01 using PERFORM in isql 4.10. >When I try to generate a form a use it for a query, I receive the >following errors: > > Rowids do not exist on the table > The cursor or statement is not available > >Is this error caused by fragmenting the table across dbspaces? > > Mark