Re: Informix Query Problem

> We are having a problem running a 4gl program on two of our production > machines. The program runs fine on 3 others. We are attempting to do a count > distinct to find the number of rows that are found by a query. The query which > actually returns the rows works fine, but the count distinct is giving the > "Attempt to fetch an unopen cursor." The syntax is the same as the query for > the rows, with the declare, prepare, open and fetch, in fact the open is the > statement immediatly proceding the fetch. We changed the fetch to a foreach > loop, and the program works fine. Thank you for all the replies to my problem. The problem ended up being a Unix problem as opposed to an Informix problem. The query we were trying to do was so large that we were exceeding the Unix limit of open files at one time. By changing from the Unix default of open files, we were able to eliminate the problem. Thanks again, Scott -- Scott Kaye "Were going to need another Timmy." AT&T -Mr. Lizard 100 Southgate Pkwy I can't speak for myself, so how Morristown, NJ 07960 could I speak for AT&T?