Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

---

what are stage one indexable predicates?

1 Answers  

---

What is an access path?

3 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

What keyword does an SQL SELECT statement use for a string search?

2 Answers  

---

What is clone table?

0 Answers  

---

What is a bind in db2?

0 Answers  

---

What is the difference between base table and view?

7 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---