Answer Posted / pradeep
SOC7 is a data exceptional error, means we load any junk
data into one field of a record.
we can resolve by these steps,
1.compile and run the program,in the spool we can find the
offset value for the job. note that offset value and run the
same job again with compiler option as LIST.
2.see the spool for the offset value where it is
located,means exactly in which numerical operation that
abbend occured.EG: total = salary + commision.
3.after the example statement we found the SOC7 error.
so, we knew that we found SOC7 there.
4.finally place the DISPLAY statement in the respective
paragraph we can found exactly where the updation is
failed.Means on stopped record there may be a junk value in
the record.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the result of open cursor statement?
Explain db2.
What is the purpose of using commit?
What is the max length of sqlca?
What is a buffer in memory?
Why cursor is used in db2?
What is the difference between oracle and db2?
What is plan in cobol db2?
What is database reorganization?
How to test SQL -911 error while developing COB-DB2 program
Is db2 free?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Can you tell me how can you find out the # of rows updated after an update statement?
List out the data types available.
What is lock escalation in db2?