Re: [Q] fragmentation and rowids

If the system does it, it works. If you do it on a fragmented table, it has to do it by some other method than plain rowid (possibly by fragid & rowid -- fragid is not available to users). Whatever, it is an internal decision of the engine. What you choose to do is a separate issue. If you decide to use rowids explicitly, then you had better not be working on a fragmented table without a WITH ROWIDS column. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From ilist@rmy.emory.edu Thu Mar 13 13:18 PST 1997 }From: David Williams <djw@smooth1.demon.co.uk> }Subject: Re: [Q] fragmentation and rowids }Date: Thu, 13 Mar 1997 03:06:14 +0000 }To: informix-list@rmy.emory.edu }X-Informix-List-Id: <news.35170> } }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 }