Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — 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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.