Interested to Buy Any Domain ? << Click Here >> for more details...
How to insert more than one record using insert?
- 7 Answers
- 13768 Views
- Atos Origin, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subi
Do an Insert using select
Insert into Table1(coltable1, coltable22)(select coltab21,
tab2col2 from Tab2 where <condn>)
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / flando
Sandeep Kumar had it close. I found the answer here:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp
?topic=/com.ibm.db2.udb.doc/admin/r0000970.htm
insert into tablename (col1, col2)
values (valu1, valu2), (valu1, valu2), (valu1, valu2)
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / harish
perform until ws-flag = 'y'
exec sql
insert into table('a','b','c','d','e')
values(a,b,c,d,e)
end-exec
evaluate sqlcode
when 000
continue
when 100
move 'y' to ws-flag
according to me ,pls let me any other remedy
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / nahid gorji
using insert into table1 (column-list or *) 479 select
column-list or * from another table
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sandeep kumar
insert into tablename(col1, col2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
values(valu1, valu2)
....................
....................
| Is This Answer Correct ? | 7 Yes | 8 No |
U could probably go for a bulk insert also.
try this option
insert into schema.table1
select * from schema.table2;
Cheers,
Ratheesh Nellikal
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Which component is responsible for db2 startup and shutdown?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
wht happens if we close cursor with cursor with hold option?
what is diffrence b/w file-aid tool and file-aid utility???
what is the role of the cursor in db2?
Where besides the DB2 catalog is database object information stored by DB2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How to take backup of table in db2?
how can u retrieve the data from null values using applicaion program.
What is a cursor and what is its function?
What is load replace in db2?
COBOL 
