Answer / subi

Do an Insert using select
Insert into Table1(coltable1, coltable22)(select coltab21,
tab2col2 from Tab2 where <condn>)

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)

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

Answer / nahid gorji

using insert into table1 (column-list or *) 479 select
column-list or * from another table

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)
....................
....................

Answer / ratheesh nellikal

U could probably go for a bulk insert also.
try this option

insert into schema.table1
select * from schema.table2;

Cheers,
Ratheesh Nellikal

Answer / kalone

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

On which levels locks can be applied?

0 Answers  

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

how do you resolve -805?

3 Answers   HCL,

SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.

0 Answers  

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  

is there any restrictions for unions ?

4 Answers   Patni,

What db2 400?

0 Answers  

what is plan? is plan executable or package?

4 Answers  

What is correlated subquery?

1 Answers