In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
Answer Posted / shekhar
insert into table1
select * from table2
where cond
this query will insert multiple rows at once.
there is load utility of DB2 can help in inserting bulk data from data file.
Plz correct me if i m wrong.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the role of the cursor in db2?
How to check sequence on a table in db2?
How to connect to db2 database from windows command line?
List out the data types available.
What is a db2 schema?
What is alias in db2?
Which isolation level provides highest data integrity?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Is db2 a database?
What is bind plan?
How to check table size in db2 sap?
What is meant by explain?
How does cobol compile db2 program?
What is database alias db2?
What is the physical storage length of date data type?