Answer / s

Information about recovery.

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

Name the different types of Table spaces.

5 Answers   IBM,

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

What is the maximum size of varchar data type in db2?

0 Answers  

---

What is db2 and what is the use of db2 optimizer?

0 Answers  

---