Thread: FETCH / ecpg

FETCH / ecpg

From
Johan Geuze
Date:
i'm having trouble with FETCH and ecpg..

I just get an compile error on this line

   EXEC SQL BEGIN WORK;   EXEC SQL DECLARE cursxxx CURSOR FOR       SELECT nr, xpos, ypos       INTO :ster, :xpos,
:ypos      FROM stars;
 

-> EXEC SQL FETCH all in cursxxx;    EXEC SQL CLOSE cursxxx;    EXEC SQL COMMIT;

i know this should work.. at least on a informix database..

The man for fetch tells me the same..

what am i doing wrong?

or is this option not supported for enbedded sql in c..?

plz help!

Johan Geuze