How to fetch the uncommited data from table ?



How to fetch the uncommited data from table ?..

Answer / sudhir kumar

With the help of restart checkpoint logic.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is table space in db2?

0 Answers  


Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?

1 Answers   IBM, scintel,


How to create db2 table in mainframe?

0 Answers  


What are the isolation levels possible ?

3 Answers  


What is the default page size of buffer pools?

0 Answers  






What are the contents of dclgen?

0 Answers  


db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


Explain dclgen.

0 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,


What are concurrency issues?

0 Answers  


Categories