What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What is schema in db2?

0 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?

2 Answers  

---

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

What is the result of open cursor statement?

0 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  

---

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

0 Answers  

---

Are view updateable?

0 Answers  

---

What is the use of runstats in db2?

0 Answers  

---

what is a collection?

2 Answers  

---

How do I change the column size in db2?

0 Answers  

---

What is clone table?

0 Answers  

---