How to insert more than one record using insert?
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 |
Post New Answer View All Answers
What is explain plan in db2?
What do you mean by storage group (stogroup)?
Explain the function of data manager.
Which component is responsible for processing sql statements and selecting access paths?
What is buffer pool?
How can you classify the locks in db2?
How do I change the column size in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is a bind card?
What is the maximum length of sqlca?
What is the meaning concurrency in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How to create db2 table in mainframe?
What is the default page size of buffer pools?
How can you count the number of rows from a table tab?