Re: informix 4gl and sql 7.x and rowids

DSL ROWID's are OK to use as long as you dont fragment your table across dbspaces. With 7.x, one is allowed to fragment the table across multiple dbspaces. You dont have to, but you can. When you do fragment, you can either remove references to ROWID from your programs, or ALTER your table to be WITH ROWID. The last is for backward compatibility only with programs such as yours (before your change). The ROWIDs thus created are not "real" rowids, but an additional column in the table, which will slow down your access compared to "real" rowids, but your programs would have worked. Since I never had to do this, my description may not be strictly accurate, but you get the general idea. HTH Sujit DSL <dsl@one.net> on 07/07/99 01:00:08 PM Please respond to DSL <dsl@one.net> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: informix 4gl and sql 7.x and rowids during the process of upgrading from 3.x to 7.x, we spent a lot of time removing all refs to rowid, as we were told that rowids were no longer supported ( unless the table was created "with rowid"). i just created a test program on our 7.x system selecting a record and its rowid, then updating the record "where rowid = variable_name", and, to my surprise, it worked!!!. whats the deal here? did we waste all our time removing these pesky varmints?