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.

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 difference between isnull and coalesce?

0 Answers  

---

List down the types of triggers in the db2 database?

0 Answers  

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

What is the usage of open cursor command?

0 Answers  

---

Can any one tell me about Restart logic in DB2.

2 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

What is cascading rollback?

0 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

What is isolation level?

4 Answers  

---