Can i insert bulk records into a db2 table using qmf of
spufi only............!!!

Answers were Sorted based on User's Feedback



Can i insert bulk records into a db2 table using qmf of spufi only............!!!..

Answer / krish

Bulk loading can be done using File-Aid DB2.

Is This Answer Correct ?    0 Yes 0 No

Can i insert bulk records into a db2 table using qmf of spufi only............!!!..

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

Post New Answer

More DB2 Interview Questions

What are data types?

2 Answers  


How to create db2 table in mainframe?

0 Answers  


What do you do to keep the cursor from closing after a commit?

1 Answers  


Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  


What is db2 optimizer?

0 Answers  


we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  


which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  


Can you use max on a char column?

0 Answers  


what is load and unload in db2

1 Answers   IBM,


What is an alias?

3 Answers  


Why do chiropractors use drop table?

0 Answers  


What is collection in db2 bind?

0 Answers  


Categories