Monday 11 February 2013

Errors :(

I got a error: "SQL0668N Operation not allowed for reason code 5".

The web and DB2 help gave me the description that a load was busy hapening which in this case was not True.
In the end the real error was because I had was doing a load as below:

DECLARE CURSOR1 CURSOR FOR
SELECT column1,column2
from table1 where ID not in (select ID from TABLE2);



LOAD FROM CURSOR1OF CURSOR
    INSERT INTO table2 (col1,col2);

Because the Cursor contains the table in which the load is being done it gives the reason code 5.