How can you classify the locks in db2?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is db2 look?

0 Answers  


Where are plans stored?

2 Answers  


i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,


What is sqlca?

0 Answers  


what are the bind parameters?

5 Answers   IBM,






What is CHECK PENDING ?

5 Answers  


what are bind concepts in db2 cobol?

0 Answers  


What are the Isolation levels possible ?

5 Answers  


Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,


I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,


What is the result of open cursor statement?

0 Answers  


How do I optimize a query in db2?

0 Answers  


Categories