Answer / naveen87ginjupalli

SPUFI-SQL Processing Using File Input
spufi is used to executes the SQL quries.
By using spufi we can execute more than one Query at a time
and also we can take the backup.

Answer / girish kumar

Naveen ans is correct and by using SPUFI we can find the
error code in case of query failure situation.
but it is not posssible in qmf.

How to find primary key of a table in db2?

0 Answers  

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---

What is the function of buffer manager?

1 Answers  

---

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

2 Answers  

---

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 Answers  

---

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 DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

Explain db2.

0 Answers  

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---

what is the difference between join and union?

4 Answers   IBM,

---

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---