Re: How to do "matches" in C-ISAM version 6

}From: john@a3bgate.nai.net (john) }Date: 30 Oct 1996 20:00:47 GMT }X-Informix-List-Id: <news.29913> } } We have a inhouse program that runs on the command line. The program } can take arguments such as "AB" or "AB*" but not "*AB*". } } I have the source of the program and think the problem is caused by } a line that says the following: } } if ((cc = isstart(fd, &key, length, rec, ISEQUAL) == 0) { } /* print out records that start with AB or match AB* */ } } } } Is there a way to make "*AB*" work? I had hoped that there was a } ISMATCHES but there was none. No, there isn't a way to do indexed reads when you have the wildcard metacharacter ('*') at the start of the matches string. The Informix optimizers (SE and OnLine) are forced into a sequential scan to handle such queries. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>