Answer / ms. stanley

SPUFI = SQL Processing Using File Input

Answer / saravanan

sql processor using file input

Answer / ramesh m

SPUFI used to write the query to select, insert, update or
delete the rows for particular acct in DB2 tables. this
will be used in any of the release or deployment. we can
select this utility from DB2 Interactive Menu. The
advantage in using this tool is we can do the multiple
perform in one SPUFI file. The output will be created with
the status of query run.

Answer / kumar

It is Sequential processing using file input.

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 a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What is runstats and reorg in db2?

0 Answers  

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

What are the levels of isolation available with DB2V4

2 Answers   IBM,

---

What is the size of a data page?

2 Answers   IBM,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

What is check constraint in db2?

0 Answers  

---

How do you filter out the rows retrieved from a Db2 table ?

1 Answers  

---