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 a Database Request Module(DBRM)?
is there any restrictions for unions ?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
What does db2 mean?
What does DSNDB07 database do?
What is cobol db2?
What is DCLGEN?
When is the authorization check on DB2 objects done - at BIND time or run time?
How to resolve -504 sql code in DB2?
How to define the data items to receive the fetch items for the SQL?
What is innodb buffer pool?
What is coalesce in db2?