how do we solve soc 7 and soc4 ?

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


Please Help Members By Posting Answers For Below Questions

What is the result of open cursor statement?

636


Explain db2.

612


What is the purpose of using commit?

616


What is the max length of sqlca?

761


What is a buffer in memory?

598






Why cursor is used in db2?

572


What is the difference between oracle and db2?

585


What is plan in cobol db2?

589


What is database reorganization?

587


How to test SQL -911 error while developing COB-DB2 program

6710


Is db2 free?

684


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

712


Can you tell me how can you find out the # of rows updated after an update statement?

610


List out the data types available.

700


What is lock escalation in db2?

574