what is static sql? what is dynamic sql? Give me details

3 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What are the three lock types?

2 Answers  

---