why we go for SPUFI for creating tables or for sql queries?
- 4 Answers
- 8458 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 a cursor and what is its function?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
is it compulsory commitment control in journal?
What is bind and rebind in db2?
Mention the different locking levels that are available in db2.
what is the use of bind parameter, Replace?
What if we fail to give values in columns declared as NOT NULL ?
What is the purpose of the DSNC transaction ?
Is the primary key a clustered index?
What is the physical storage length of the data types date, time, and timestamp?
COBOL 
