Re: ROWID's

Tim Schaefer wrote: > > Cheryl Kendricks wrote: > > > > As a DBA I hope it IS!!! > > > As a developer I'm saddened by the loss of a really great feature of the > early engines. This was a built-in serial key I never had to add to my tables. > I'll miss being able to fetch a selected-set of ROWIDs, which was and is a > nice compact selected-set, and be able to damn near guarantee what row I want > to work on. Updating by means of a "WHERE CURRENT OF" syntax was only good > if you didn't ( and don't ) need to use the ORDER BY syntax. > > If I used a Next-Previous fetch looking for a ROWID instead of something else, > I knew ( and know ) I updated the right row. There's probably another way, > I learn something new every day. But it's sad too, that soon everyone will > be querying across networks instead of vt100 terminal sessions, and selected > set management will soon become something you'll be paying attention too. > > To say say it's some kind of "good thing it doesn't exist" doesn't really > make any sense. I think it would have been just as easy to retain the unique > ROWIDs across fragments, but hey, I'm no computer scientist. Had INFORMIX > retained this feature we wouldn't even be having this chat. Now I incur the > extra overhead of serial keys all over the application and data base. No > big deal. What's an extra index...we'll be buying some newer and faster > computers soon anyway... > > :-) > And yes I know you can add the ROWID manually in 7.1...I read the manual... :-) Tim