Answer / s

Updated pages are not written immediately to the DASD. Upto
32 pages can be written with 1 I/O and is called a deferred
write. Asychronous means the SQL request does not wait for
the Write I/O to happen.

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

What is a thread?

3 Answers  

---

Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,

---

What is the picture clause of the null indicator variable?

6 Answers  

---

Mention the location where the output received from explain statement is stored.

0 Answers  

---

What is cloudant database?

0 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,

---

How do I import data from excel to db2?

0 Answers  

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What is UNION,UNION ALL?

2 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---