Index problem

I recently migrated from IDS 7.31.UC5-1 to IDS2000 9.21HC3-1 on HPUX 11.0. I was sure I followed the migration steps to the letter, but now every time I compile a form, using sformbld, I get error messages advising me to put indexes on prominent fields. Well, these fields are indexed, the sysindexes table includes them. Even though the forms compile and seem to run fine I'm worried there is some compromising going on. Could there be a corrupt system table I'm unaware of and what could I do to repair it? I have done update statistics. The databases are small by today's standards (none over 200,000 rows). Any tips, clues or resolutions for this problem are already appreciated. Thanks, Deb Nicke

"Nicke, Deb" wrote: > I recently migrated from IDS 7.31.UC5-1 to IDS2000 9.21HC3-1 on HPUX 11.0. I was > sure I followed the migration steps to the letter, but now every time I compile > a form, using sformbld, I get error messages advising me to put indexes on > prominent fields. Are they error messages or warnings? If, as I suspect, they are warnings, then ignore them and use the compiled forms. I'd have to guess that the code in the form compiler which is identifying indexes isn't working correctly, possibly because sysindexes in 9.x is a view and not a table as it was until the 9.x servers. > Well, these fields are indexed, the sysindexes table includes > them. Even though the forms compile and seem to run fine I'm worried there is > some compromising going on. Could there be a corrupt system table I'm unaware > of and what could I do to repair it? I have done update statistics. The > databases are small by today's standards (none over 200,000 rows). Any tips, > clues or resolutions for this problem are already appreciated. Obviously, there might be some corruption; run oncheck to test this. However, I think it more likely that ISQL (sformbld) is being confused than that there is anything seriously astray with the database itself. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"