Re: [Q] fragmentation and rowids

Posted in 1997

David Williams — Thu, 13 Mar 1997 03:06:14 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <5g6sta$q25@cssun.mathcs.emory.edu>, Jonathan Leffler <johnl@informix.com> writes >No. ISQL Forms use ROWIDS. ROWIDS are not available with fragmented tables >unless you add the WITH ROWIDS option. > >This is clearly documented in the release notes (release/TOOLREL_6.04). > >Sorry, but that's the way it is. > I have been writing 4GL code today which used update cursors and UPDATE ...WHERE CURRENT OF..... I notice in sqexplain.out that it shows ROWID as the method used to access the row I am updating...will this sytnax also fail on fragmented tables? >Yours, >Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> > >>From: Chree Haas <haas@spiker.dfw.net.informix.com> >>Date: 11 Mar 1997 17:26:06 GMT >>X-Informix-List-Id: <news.35095> >> >> I've just started working with fragmentation under ODS 7.13. >>Everything works fine until I go into isql, v 6.03. Querying using >>forms yields errors about rowid's being nonexistent. Is there any >>way to bring this tool back to life, other than adding a rowid column? -- David Williams