Answer / s

Drops the plan.

Answer / sv kumar

it will delete that existing plan

What is Skeleton cursor table (SKCT)?

2 Answers  

---

When the like statement is used?

0 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  

---

Which isolation level provides maximum concurrency?

0 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

What is dbrm? When it will be created?

0 Answers  

---

What is sqlca?

0 Answers  

---

how to resolve -818 error. how to see timestamp token in load module and plan

4 Answers   IBM,

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 Answers  

---