How can I insert multiple rows in a DB2 table

naveensrimf · New User Joined: 04 Oct 2005 Posts: 34

How can I insert multiple rows in a DB2 table? Could you please give some Examples.

Dsingh29 · Active User Joined: 16 Dec 2008 Posts: 132 Location: IBM

two options that I know of are :

1. INSERT INTO Table1 VALUES(12, 12.00)
INSERT INTO Table1 VALUES(11, 13.00)

2. INSERT INTO Table2
SELECT Column1, Column2 FROM Table1 where column1=value

gylbharat · Posted: Tue Jul 19, 2011 2:05 pm

If the number of rows are too huge... you can try using LOAD utility...

GuyC · Posted: Tue Jul 19, 2011 2:29 pm

not a question for expert fora

enrico-sorichetti · Posted: Tue Jul 19, 2011 2:36 pm

speak louder, it' s difficult to hear You

dbzTHEdinosauer · Posted: Tue Jul 19, 2011 2:51 pm

stopped being an expert forum a long time ago.

This forum is a place where people can get expert assistance for their jobs.

GuyC · Posted: Tue Jul 19, 2011 5:16 pm

they don't need expert assistance, they need basic training