What does db2 plan contain?

0 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

What is clone table?

0 Answers  

---

How do I delete a table in database?

0 Answers  

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

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,

---

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 cobol db2?

0 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What is concurrency?

0 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---