Tomorrow I'll be upgrading a client from 7.6 to 9.5. I'm testing an "unload
all" on their database in preparation. I got an error because on several (but
not all) of the "create index" commands there was something like this:
CREATE INDEX RecDate ON `Recpts` (`RecDate` ASC SIZE 1 )
The "size 1" (there are other sizes on other indexes) produce errors in 9.5.
Simple fix, I just erased all the sizes in my unload command. But I'm just
curious what made those sizes go in there since I don't remember ever
specifying an index "size" at any point. Do those sizes go back to DOS days
when someone else had originally created this database?
Karen
