What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

What is buffer pool and list some of them?

0 Answers  

---

What is a DB2 bind?

3 Answers  

---

Is db2 a mainframe database?

0 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  

---

What is the result of open cursor statement?

0 Answers  

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

What is the difference between base table and view?

7 Answers  

---

What is the database descriptor?

2 Answers  

---

what is the responsibility of the construction superintendent

0 Answers   Almco,

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  

---