common errors

What are common errors you faced in
cobol,db2,jcl
how to solve them

In cobol, relatated to flat files during runtime
1)39---mismatch in length of dataset record (check for LRECL of dataset specified in DDname of JCL and Input-output section of SELECT statement)
2)10-End of the file or no more records to read
In JCL
--------
1)S0C7---Data exception error(check for the values being moved to Numeric fields with the help of offset value)
2)S0C4-- Protect Exception(a.check for subcript value whether it is exeeding the specified limit.b.check for INITIALIZE statement whether it is written before OPEN filename statment. c. Check for calling program "call pgm1 using" parameters and called pgogram's linkage section parameters)
In DB2
---------
1.-305------null indicator not specified for nullable field
2.-310-----variable defined with COMP-3 is receiving non PACKED-DECIMAL value.
3.-180&181---date format and invalid date
4.-206---column name not found in the table
5.-501---cursor not opened for fetch or close
6.-530--referential integrity for insert/update
7.-532--referential integrity for Delete.
8.-803---duplicate key on inserttion
9.-805---plan name not found
10.-811---multiple records returned for select statment
11.-818--timestamp mismatch