If we want to insert more than 1 row into a table , we should go for SUBQ

How to insert more than one record using insert?

Question Posted / kalone

Answer Posted / kalone

If we want to insert more than 1 row into a table , we
should go for SUBQUERIES rather than VALUES clause.

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can you find out the # of rows updated after an update statement?

732

What is ibm db2 connect?

651

Are view updateable?

710

Why db2 is called db2?

671

What is alias in db2?

678

How can deadlocks be resolved?

625

Define db2.

756

What is declare cursor?

706

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

705

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

725

What is the physical storage length of time data type?

767

Is it possible using max on a char column?

703

What is the syntax for creating a table in the db2 database?

720

What is the cobol picture clause of the db2 data types date, time, timestamp?

705

What are union and union all?

625