Re: [Q] fragmentation and rowids

Chree Haas <haas@spiker.dfw.net> wrote in article <5g44je$909@fnord.dfw.net>... > Hey all, > 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? I haven't used isql, but from what I understand about table fragmention, each table fragment has it own rowids, and therefore rowid is no longer unique. To explain, if your table is fragmented over three dbspaces, then you will have three rowids of 1, three rowids of 2 and so on. This may be causing isql some problem. This is the reason we haven't started using table fragmentation yet - the application uses rowid. What I plan on doing is renaming the tables I am going to fragment, then create a view of that table with the origanal name. Then when the application queries the table, it will be accessing the data from the view which will have unique rowids. Any comments on this approach would be appreciated.