Answer Posted / prabu

select getdate()

In SQL Server, We can get current date and time
If this answer is not correct give me feedback

Is ibm db2 open source?

1127

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9353

---

What is difference between rollback and commit?

1203

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1288

---

What is reorg?

1238

---

What is runstats utility in db2?

1066

---

Mention the different locking levels that are available in db2.

1183

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1138

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1109

---

Explain db2.

1084

---

What is the difference between bind and rebind in db2?

1505

---

What is access path in db2?

1042

---

Explain dclgen.

1268

---

Explain various types of locks in db2?

1204

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1128

---