why we go for SPUFI for creating tables or for sql queries?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is the difference between drop table and delete table?
What are union and union all?
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
What is db2 bind?
What is the use of db2?
What does CURRENTDATA option in bind indicate
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is a plan and how do you refer the plan in the program?
What is isolation level?
Is there any advantage to denormalizing DB2 tables?
Define db2 and its databases?
What is the STOSPACE Utility used for?