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 |
Is db2 a programming language?
where will u check for sqlcode ?
How do you concatenate the firstname and lastname from emp table to give a complete name?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
Comment whether the cursor is closed during commit or not.
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What does db2 blu stand for?
What are the Isolation levels possible ?
What is db2 bind?
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.
what is sql abend code -801,-802?
What is Call attach facility? How does it work?