What is the difference between cursor and select statement?

0 Answers  

---

Comment whether the cursor is closed during commit or not.

0 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

How do I delete a column in db2?

0 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

---

How would the varchar column remarks defined?

0 Answers  

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

What is null indicator in db2?

0 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

What is the purpose of the DSNC transaction ?

1 Answers  

---