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.

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

What types of tables are there in the db2 database?

0 Answers  

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

What are union and union all?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

---

How to connect to db2 database from windows command line?

0 Answers  

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

What is correlated subquery?

1 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  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---