Interested to Buy Any Domain ? << Click Here >> for more details...
why we go for SPUFI for creating tables or for sql queries?
- 4 Answers
- 10229 Views
- I also Faced
- E-Mail Answers
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 db2 stogroup?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
how can you access index
What is meant by AUTO COMMIT?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
How to get Top 10 Salaries from a Table
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How to create a table using embedded sql?
What is difference between rollback and commit?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
COBOL 
