why we go for SPUFI for creating tables or for sql queries?
- 4 Answers
- 8856 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 |
How will fetch last 5 rows from table in db2
What is an instance database?
db2 restart logic ?
Mention the downsides of page level lock.
What is the physical storage length of time data type?
What is the picture clause of the null indicator variable?
What is cursor stability?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
How is the SUBSTR keyword used in sql?
What is a cursor?
How is the value function used?
COBOL 
