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

Can there be more than one cursor open for any program?

1123

What does db2 mean?

955

Mention the location where the output received from explain statement is stored.

1054

Give the name of some fields form sqlca.

1022

What is load utility in db2?

1130

What is the use of db2?

1006

How do you eliminate duplicate values in db2?

1108

What is nvl in db2?

1040

How would you find out the total number of rows in a db2 table?

989

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2167

How will you return the number of records in table?

880

How can we retrieve the total number of records in RPG & CLLE?

577

What do you mean by storage group (stogroup)?

984

What is the difference between cursor stability and repeatable read isolation levels?

1115

What are db2 tables?

1050