how do we solve soc 7 and soc4 ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sujith
Hi,
There can be many methods to solve SOC7
1)by using XPEDITER
2)Going behind the reasons causing Soc7 in working -
storage. (we can offset the wrong data and compile and
later correct it)
3)the most preferable one is to get the value of offset in
compile list,getting this offset then find this offset's
corresponding value in your pgm.It will take you straight
to the line causing SOC7.
SOC 4 may be due to less space than what is needed by the
program. This is also called Storage violation error - can
be due to various
reasons. e.g.: READING a file that is not open, invalid
address referenced due to subscript error.
Using Display statements points or after lines you suspect
can show where the error occurs.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / praveen
soc 7
compile with list option.
soc 4
nossrange
Is This Answer Correct ? | 1 Yes | 1 No |
How do I optimize a query in db2?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What techniques are used to retrieve data from more than one table in a single SQL statement?
What is db2 bind process?
When is the access path determined for dynamic SQL?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What are the uses of db2 optimizer?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What are the different types of base tables?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)