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

Is it possible to create an Instance in DB2 using DB2 Control Center ?

618


What are the various isolation levels possible?

638


What is the function of logging in the db2 database?

636


What is db2 catalog database?

572


Is schema the same as database?

621






What is database alias db2?

591


What are the rules for db2 programming?

635


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

576


What is cloudant database?

636


What is with ur in db2?

744


What is cascading rollback?

613


How to take backup of table in db2?

591


What is the latest version of ibm db2?

728


Explain package in db2 and its advantages?

588


What is page size in db2?

559