why we go for SPUFI for creating tables or for sql queries?

Answers were Sorted based on User's Feedback



why we go for SPUFI for creating tables or for sql queries?..

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.

Is This Answer Correct ?    4 Yes 0 No

why we go for SPUFI for creating tables or for sql queries?..

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.

Is This Answer Correct ?    0 Yes 0 No

why we go for SPUFI for creating tables or for sql queries?..

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.

Is This Answer Correct ?    0 Yes 0 No

why we go for SPUFI for creating tables or for sql queries?..

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

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What is the difference between drop table and delete table?

0 Answers  


What are union and union all?

0 Answers  


if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


What is db2 bind?

0 Answers  


What is the use of db2?

0 Answers  






What does CURRENTDATA option in bind indicate

1 Answers   IBM,


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  


what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,


What is isolation level?

4 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Define db2 and its databases?

0 Answers  


What is the STOSPACE Utility used for?

1 Answers  


Categories