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 |
What is consistency token in db2?
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 .
How to create backup table in db2?
what is a collection?
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?
What is image copy?
How do I copy a table in db2?
What is correlated subquery?
what is load and unload in db2
What is meant by a unit of recovery?
What is referential integrity?
What technique is used to retrieve data from more than one table in a single SQL statement?