What is meant by concurrency?

1 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

What is a collection?

3 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

What is the max length of sqlca?

0 Answers  

---

Who uses db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

How to take backup of table in db2?

0 Answers  

---

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

1 Answers  

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---