why we go for SPUFI for creating tables or for sql queries?
Answer Posted / 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 |
Post New Answer View All Answers
can we view the access paths created by dbrm ? how ? thx
Can one database have multiple instances?
What is dbrm library?
Which component is used to execute the sql statements?
What is the use of value function?
What is coalesce in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is bind plan?
If I have a view which is a join of two or more tables, can this view be updateable?
How can record locking be achieved in those DB2 versions which do not support it?
what is diffrence b/w file-aid tool and file-aid utility???
What are the contents of dclgen?
What is the reason behind not using select * in embedded sql programs?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the usage of open cursor command?