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 is consistency token in db2?

1 Answers  


SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,


How to create backup table in db2?

1 Answers  


what is a collection?

2 Answers  


A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,


What is image copy?

1 Answers   Virtusa,


How do I copy a table in db2?

1 Answers  


What is correlated subquery?

1 Answers  


what is load and unload in db2

1 Answers   IBM,


What is meant by a unit of recovery?

1 Answers  


What is referential integrity?

5 Answers  


What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,


Categories