Interested to Buy Any Domain ? << Click Here >> for more details...
In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
- 5 Answers
- 20144 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / uma
We can't insert multiple row in single query for the we
have to use cursor.
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is the purpose of using commit?
what are bind concepts in db2 cobol?
What is host variable?
What is cursor stability in db2?
How and when does the db2 enforces the unique key?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
How can record locking be achieved in those DB2 versions which do not support it?
Which component is responsible for db2 startup and shutdown?
What is coalesce in db2?
What is the difference between cursor stability and repeatable read isolation levels?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a system catalog table in db2?
What is the connection string to connect to the DB2 Database ?
What is the difference between drop table and delete table?
