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.

How does DB2 determine what lock-size to use?

2 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

Name some fields from SQLCA.

2 Answers  

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers   Syntel,

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---