Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

What is a host variable?

3 Answers  

---

What is db2 stogroup?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

Where can you declare a cursor in a cobol-db2 program?

0 Answers  

---

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

---

What is null indicator in cobol db2?

0 Answers  

---

How can you classify the locks in db2?

0 Answers  

---