How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is difference between isnull and coalesce?

0 Answers  

---

How to define the data items to receive the fetch items for the SQL?

2 Answers  

---

What is meant by the attachment facility?

3 Answers  

---

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

What is a dbrm in db2?

0 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---