Answer / shubham

select substr(Stud_Name,1,5) from Table;

When is the access path determined for dynamic SQL?

2 Answers  

---

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

0 Answers  

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---

What is db2 purescale?

0 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

How does DB2 use multiple table indexes?

1 Answers  

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---