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 a db2 tablespace?
What is syscat in db2?
What is the connection string to connect to the DB2 Database ?
What is rct?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what is db2 restart?
How can you classify the locks in db2?
Define db2 and its databases?
How to execute stored procedures?
What is the use of reorg in db2?
What is explain in db2?
What is the syntax for FETCH in DB2 ?
Outputs of explain are with matchcols = 0. What does this signify?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Is db2 a programming language?