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
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the various data types available in db2?
What is the use of dclgen in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is host variable in db2 cobol?
What is rct?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
define clustering index.
What r the comman abends in db2, jcl and cobol???????
What is null in db2?
How to access db2 tables in mainframe?
How is a typical db2 batch pgm executed?
Why db2 is called db2?
Which component is used to execute the sql statements?
What is the difference between plan and package in db2?