Answer / sneha

its due to time stamp mismatch .Bind the job once again and
link it

Answer / arunshan

this is timestamp mismatch this will come only when you
directely bind the dbrm in to plan..
to rectify that check whether you have binded the correct dbrm.

if not rebind it again.

what is sql abend code -801,-802?

2 Answers  

---

What is a db2 schema?

0 Answers  

---

What is QUIESCE?

2 Answers  

---

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 does sqlcabc has?

0 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

Is db2 a mainframe database?

0 Answers  

---