Re: -404 on OPEN cursor

In article <3352A9B8.3961@bigfoot.com>, Daniel says... > >This is either something really stupid on my part, or a real problem. > >I prepare a select statement >(SQLCODE == 0) after the prepare >I Declare a cursor for the prepared statement >(SQLCODE == 0) after the declare >I OPEN the cursor I just declared >SQLCODE == -404 (Cursor not available) > >I triple checked that the cursor name I tried to open was the same as >the one I declared, and did the same for the statement I prepared and >declared the cursor from. > >Any ideas will be most appreciated, > >(The cursor appears in an ESQL/C module which is compiled along with a >4GL module into an executable - the cursor is in the E/C because that's >where the variables I intend to use exist; > I wrote a short EC program to verify that I was preparing, declaring >and opening properly; > HP-UX 10; Informix 7.21) Daniel, I have seen this when a user compiled with a makefile where incorrect options were passed to the compiler. If you are using makefile, try to revise it and make sure: - esql compiler is used, not cc with explicit list - only valid esql options are passed (in my case it was C-specific dynamic compilation flag which confused the thing) Regards ILya