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
Name the lockable units in DB2?
What is bind package and plan in db2?
What is cobol db2?
What are the 2 sqlcodes that are returned?
What is null value in db2?
What is cascading rollback?
What is the difference between dbm cfg and db cfg file in db2 ?
What is a buffer in memory?
What is copy pending status in db2?
What are the full forms of spufi and dclgen and why are they used?
What is an instance in db2?
What is the role of union all and union
Highlight all the advantages that are attached to a package.
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
If I have a view which is a join of two or more tables, can this view be updateable?