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