Why SQL3304N The table does not exist soon after a Declare Cursor was executed & successful?
Posted on 2010-09-09
Something baffles me here. The code that you see was executed successfully and rows were loaded. Notlong after I decided to test again but now I am getting the following error:
db2 => DECLARE LOAD_CUR1 CURSOR DATABASE DB2DB USER myusrid USING mypasswd FOR SELECT * FROM ECDP012.RCATB_SMS_CDM;
DB20000I The SQL command completed successfully.
db2 => LOAD FROM LOAD_CUR1 OF CURSOR warningcount 20 REPLACE INTO ECDBT012.RCATB_SMS_CDM;
SQL3304N The table does not exist.
What exactly is happening here? Anyone seen this type of event before and how can I resolve the matter?