store procedure to insert multiple records at a time into table?

[sachingarje26]

i am new to db2 database , want to create a stored procedure for How to Insert entire DataTable into DB2 at once instead of row by row? please help me out with this.

[Frinavale]

Is the data you want to insert into the Data Table already in another Data Table (or tables)?

You can use the Select statement with the Insert statement like this:

Insert Into Table1(ColID, ColNumber, ColDate)
Select tbl2ID, tbl2NO, tbl2Date FROM Table2