What do you need to do before you do EXPLAIN?

1 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

Write a query to retrive partial string.

2 Answers  

---

What is a synonym ?

2 Answers  

---

What are host variables in db2?

0 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

List down the types of triggers in the db2 database?

0 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

What is the FREE command?

1 Answers  

---