Can i insert bulk records into a db2 table using qmf of
spufi only............!!!
Answers were Sorted based on User's Feedback
Answer / srini
Thru SPUFI/QMF/FileAID you can insert bulk records by
selecting the records from one table and inserting into
other one.
| Is This Answer Correct ? | 0 Yes | 2 No |
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Describe the elements of the SELECT query syntax?
What happens in bind step in a db2 program?
How would one remove old reorg information from the DB2 catalog?
What are host variables in db2?
What else is there in the PLAN apart from the access path?
What are the four lockable units for DB2?
What is a Database Request Module(DBRM)?
What is innodb buffer pool?
What is cascading rollback?
How are write I/Os from the buffer pool executed?