In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
Answer Posted / siri
insert into tableName
(col1, col2, col3, col4, col5)
values
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5),
(val1, val2, val3, val4, val5);
Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Differentiate between cs and rr isolation levels? Where do you specify them?
What is dbrm? What it contains? When it will be created?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the use of commit in db2?
Explain correlated sub-queries.
What are db2 tables?
What is commit in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
can we view the access paths created by dbrm ? how ? thx
Why do we bind in db2?
How do you find the maximum value in a column in db2?
How to find the maximum value in a column in the db2 database?
What is host variable?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is host variable in db2 cobol?