How would the varchar column remarks defined?

0 Answers  

---

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

3 Answers  

---

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,

---

What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

---

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What does the CHECK Utility do ?

1 Answers  

---

How to connect to db2 database from windows command line?

0 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

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 advantages of using a PACKAGE?

2 Answers  

---

What is a Foreign Key?

0 Answers   Tavant Technologies, Zensar,

---