Answer / Rakesh Kumar Maurya

DCLGEN is a utility program provided with DB2 to generate DDL (Data Definition Language) statements for creating database objects, such as tables and indexes, based on a COBOL copybook.

How to find the number of rows in db2 tables?

1 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,

---

Explain about rct.

1 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  

---

What is dbrm? When it will be created?

1 Answers  

---

what is sql abend code -801,-802?

2 Answers  

---

What's The Percentage Free Space ?

1 Answers   IBM,

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is the meaning concurrency in the db2 database?

1 Answers  

---

What is a host variable?

3 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

wht is d/f between union and joins ?

2 Answers  

---