Interested to Buy Any Domain ? << Click Here >> for more details...
How to insert more than one record using insert?
- 7 Answers
- 13766 Views
- Atos Origin, IBM, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikal
U could probably go for a bulk insert also.
try this option
insert into schema.table1
select * from schema.table2;
Cheers,
Ratheesh Nellikal
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are db2 objects?
What is database manager in db2?
What is the difference between spufi and qmf?
what is diffrence b/w file-aid tool and file-aid utility???
What are db2 tables?
Which component is responsible for processing sql statements and selecting access paths?
What is copy pending and check pending in db2?
On which levels locks can be applied?
What is the use of reorg in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are concurrency issues?
How do I change the column size in db2?
Outputs of explain are with matchcols = 0. What does this signify?
How do you pull up a query which was previously saved in qmf?
What is cursor in dbms?
