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.

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---

What is lock escalation?

2 Answers  

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

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,

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

What are packages in db2?

0 Answers  

---

What is DYNSLT keyword? How do you perform selection using DYNSLT

1 Answers  

---