5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What information is contained in a SYSCOPY entry?

2 Answers  

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

---

What is db2 optimizer?

0 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---

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  

---

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

2 Answers  

---