Answer / kamal

chek point is used to when more than one record update in
ur cobol/jcl pgm using RD parameter with chekpoint
is mainrole.because every 100 record or userdefine with
chek your result table.abnormally terminated ur pgm not
updated where i mention your last check point.
Rd parameter following types.
rd=restart
rd=rnc(restart no ckekpont)
rd=rc(restart with chekpoint)
*every abnormal execution system automatically restart
(using checkpoint with restart option)

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

what is REORG? what is the use?

4 Answers  

---

What is image copy?

1 Answers   Virtusa,

---

What is db2 and what is the use of db2 optimizer?

0 Answers  

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

How can you quickly find out the # of rows updated after an update statement?

0 Answers  

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

What is load utility in db2?

0 Answers  

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---