Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how do we solve soc 7 and soc4 ?

Answers were Sorted based on User's Feedback



how do we solve soc 7 and soc4 ?..

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

how do we solve soc 7 and soc4 ?..

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

how do we solve soc 7 and soc4 ?..

Answer / praveen

soc 7
compile with list option.
soc 4
nossrange

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,


in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,


Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?

2 Answers  


what are stage one indexable predicates?

1 Answers  


Can we update view in db2?

0 Answers  


How to find the maximum value in a column in the db2 database?

0 Answers  


Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  


i want to delete 20th million record how ?

4 Answers   IBM,


How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  


Explain what are the various isolation levels possible?

0 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


What is query_cache_limit?

0 Answers  


Categories