i want to delete 20th million record how ?

4 Answers   IBM,

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

0 Answers  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

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

3 Answers   Syntel,

---

Explain how can you do the explain of a dynamic sql statement?

0 Answers  

---

What are catalog tables in db2?

0 Answers  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

Can you use max on a char column?

0 Answers  

---

What is the clustering index in the db2 database?

0 Answers  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---