Page 1 of 1

Difference of INSERT thought LOAD and Normal INSERT

PostPosted: Fri Feb 08, 2013 5:12 pm
by fornanthakumar
Hi,

Just an query,

1. I have noticed that , when an TABLE in COPYPENDING stage

--> I can insert the data through LOAD anyway the table will again put in COPYPENDING but the desired data loaded into the table.
--> Unfortunately i could not insert the data through DB2-cOBOL PRogram or SPUFI..

Can anyone explain why the issue is.

Re: Difference of INSERT thought LOAD and Normal INSERT

PostPosted: Fri Feb 08, 2013 9:42 pm
by GuyC
First you have to understand what copypending means and why :
Copypending means that the table is in a unrecoverable state. If an error occurs on that table, it will be impossible to rollback. So DB2 does not allow you to do update or inserts.
It is perfectly possible to do some more unrecoverable stuff to the table like Load (log no)