Are views updatable ?

4 Answers  

---

What is load utility in db2?

0 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

How to find primary key of a table in db2?

0 Answers  

---

What is the STOSPACE Utility used for?

1 Answers  

---

What is a base table?

2 Answers  

---

how to check the table is empty or not?

3 Answers   IBM,

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

wht is d/f between union and joins ?

2 Answers  

---

Name some fields from SQLCA

1 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  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---