What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,

---

What is the meaning of -805 SQL return code?

3 Answers  

---

What is the purpose of rollback and commit?

0 Answers  

---

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

---

What is COPY PENDING status?

6 Answers  

---

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

What is an inner join, and an outer join ?

1 Answers   CTA,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

---

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  

---