Answer / tintu raveendran

It is the process of creating an executable module from the
source DBRM. Its functions are,
Checks the syntax of the SQL defined in the program (DBRM)
Checks whether the object accessed by the SQL physically
exists.
Does an authorization check.
Creates the optimum access path for the query using the
DB2 optimizer.

What is DCLGEN ?

3 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

What is a correlated sub query?

2 Answers  

---

What does runstats do in db2?

0 Answers  

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

what is difference between Plan and Package

1 Answers   Syntel,

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---

What is EXPLAIN?

1 Answers  

---