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 are data types?
How to create db2 table in mainframe?
What do you do to keep the cursor from closing after a commit?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is db2 optimizer?
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?
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.?
Can you use max on a char column?
what is load and unload in db2
What is an alias?
Why do chiropractors use drop table?
What is collection in db2 bind?