Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

What is cursor in dbms?

0 Answers  

---

Once you create a view, where would information about the view be stored?

1 Answers  

---

What is sqlcode -922 ?

2 Answers  

---

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

Is db2 a programming language?

0 Answers  

---

What is the purpose of the WHENEVER statement?

1 Answers  

---

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What is the error code -803 ?

3 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---