Can I use LOCK TABLE on a view?

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  

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---

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

2 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

why we create view.

5 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---

What is a page?

2 Answers  

---