Stored procedure for db2 copy data from existing table to another table

dbsam · #1 (**permalink**) 07-20-11, 17:15

Hi All,

I have a requirement to copy all data from an existing table to another table. I need to write a stored procedure for that. COuld you please help me write a stored procedure. Ihave never written one before. so will be a good learning experience for me.

Thanks

dbsam

n_i · #2 (**permalink**) 07-20-11, 21:56

I'm not sure if you really need a stored procedure for that, but there are some examples in the manual: README

dbsam · #3 (**permalink**) 07-21-11, 09:03

Thanks so much for your reply. Could you please provide me the link

dbsam

stolze · #4 (**permalink**) 07-22-11, 07:18

Copying data can be done with a simple "INSERT INTO <target> SELECT <column-list> FROM <source>". The only thing why you want to do it more complicated is to execute intermediate COMMIT statements.

JAYANTA_DATTA · #5 (**permalink**) 07-22-11, 19:13

If you do the above with shell scripts its easier and simple. But still if there is a need to copy and move data using Stored Procedure in DB2, then you can use ADMIN_CMD stored procs "ADMIN_CMD procedure is used by applications to run administrative commands using the SQL CALL statement. "

Internet Services

Web Development

Digital Marketing

Consumer Tech