How to check sequence on a table in db2?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

0 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

What is the difference between Primary key and unique index?

6 Answers  

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---