Cursor and Fetch Problem of INFORMIX? - TechRepublic
General discussion
February 4, 2002 at 02:32 PM
wang_bo/gx/ccb

Cursor and Fetch Problem of INFORMIX?

by wang_bo/gx/ccb . Updated 24 years, 2 months ago

I use INFORMIX DYNAMIC SERVER 9.21UC5 on AIX4.3.3 with ML08, in one program, I do this:


$ delcare c_cur cursor for select * from s_table;
$ open c_cur;
$ fetch c_cur;
while sqlca.sqlcode==0
{
do something;
$ fetch c_cur;}
put it simple, I have omitted the error dection syntax. the problem is:
ON theory, It let me fetch every record of table s_table, but occasionally It does not : some rows are not fetched or one row is fetched more than one time , can this be possible?

This discussion is locked

All Comments