Answer / amarnadh reddy

If we set SQLCODE=100 means end of the table.

EX: if sqlcode=100
Display end of the table
end-if.

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

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,

---

What is query_cache_limit?

0 Answers  

---

What is a DB2 bind?

3 Answers  

---

define clustering index.

0 Answers  

---

What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,

---

Explain about cursor stability?

0 Answers  

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

What is reorg in DB2

3 Answers   Virtusa,

---