Answer / girish kumar

By using SPUFI we can get the error code when the query fails, and at a time we can execute multiple queries.
QMF doesn't support to execute multiple queries at a time.

Answer / vijay krishna

SPUFI is abbreviated as SQL Processing for File Input.
Through SPUFI, you can execute a set of queries one time by
feeding an input file and whereas through QMF, you can
execute only one query at a time.

Answer / satty

becoz spufi is interactive and spontaneous which makes user
to create faster and allows user to know whats wrong when
there is error.

Answer / hemant

see man first of all we need to know full form of sql..it
is structured query language...now why we use sql.this
question arises

What's The Percentage Free Space ?

0 Answers   IBM,

---

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

1 Answers  

---

What is tablespace?

3 Answers  

---

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 Answers  

---

What will happen, while trying to close the closed cursor.

1 Answers  

---

What is a base table?

2 Answers  

---

How can we retrieve the total number of records in RPG & CLLE?

0 Answers  

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

Define db2.

0 Answers  

---

What does it mean if the null indicator has -1, 0, -2?

1 Answers  

---

Write a query to retrive partial string.

2 Answers  

---