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

3 Answers  

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---

What are union and union all?

0 Answers  

---

Is ibm db2 free?

0 Answers  

---

What are the functions in DB2?

3 Answers   Satyam,

---