fetching problems

From: Quang Tran {82139} <qlt_at_swl.msd.ray.com>
Date: 1997/11/05
Message-ID: <63r170$j37$1@swlab1.msd.ray.com>#1/1

I have no problems with sqlca.sqlcode till fetching each row to output file as following: EXEC SQL PREPARE temp FROM :statement;
EXEC SQL DECLARE temp_cursor CURSOR for temp; EXEC SQL OPEN temp_cursor;
Till here sqlca.sqlcode = 0;
But as I try to fetch the first time with all ten tables (about 20,000 rows) by

EXEC SQL FETCH temp_cursor INTO :std_name,


                                :class,

                                :teacher,

                                :room,

                                :building;

sqlca.sqlcode = -604;
However, with nine tables (about 19,000 rows) , the result was very good.
Hope you guys could help me with any suggestion, thanks vey much.
.

:wq Received on Wed Nov 05 1997 - 00:00:00 CST