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
How to compare data between two tables in db2?
What is dpf in db2?
What is a Foreign Key?
What is a page in db2?
What do you mean by storage group (stogroup)?
What is db2 catalog database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the latest version of ibm db2?
Explain the contention situations caused by locks?
How to get the ddl of a table in db2?
How to check last update on table in db2?
What are the various isolation levels possible?
What are the different types of base tables?
What is db2 stogroup?
What are the prerogatives?