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.

How many databases are there?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

How is the value function used?

0 Answers  

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

What is the error code -803 ?

3 Answers  

---

Are views updatable ?

4 Answers  

---

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

Name the different types of Table spaces.

5 Answers   IBM,

---