Answer Posted / samir kumar sahoo.

in DROP TABLE command it will remove the table containts as
well as table structure from the database catalog, also it
release all the storage space it has acquired previously.
we can't rollback it as it is a ddl command.

but in case of DELETE TABLE command it just delete all the
records but not relaese the spaces it acquires .it can be
rollback as it is a dml command.

What is db2 stogroup?

1220

---

How would the varchar column remarks defined?

1127

---

List some fields from sqlca?

1103

---

Define db2 and its databases?

1109

---

What is load replace in db2?

1042

---

Define db2.

1165

---

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 .....

2410

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2433

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2088

---

How to run db2 command in windows?

1239

---

Explain about mirror activator disk mirroring?

1059

---

Is db2 a programming language?

1095

---

What is the use of db2?

1111

---

What is schema in db2?

1079

---

What is the physical storage length of time data type?

1175

---